1.1.1

2 rows selected
Drop a configured receiver by specifying its ID:
drop gatewayreceiver testreceiver;
DROP GATEWAYSENDER
Remove a gateway sender configuration from the SQLFire cluster.
Syntax
DROP GATEWAYSENDER [ IF EXISTS ] sender-identifier
IF EXISTS
Include the IF EXISTS clause to execute the statement only if the specified sender exists in
SQLFire.
sender-identifer
Unique identifier of the gateway sender configuration that you want to remove. This corresponds
to the identifier that was supplied in the original CREATE GATEWAYSENDER statement.
You can find a list of configured senders by querying the GATEWAYSENDERS on page 657
.
Example
This command removes the gateway sender named "mysender" from all server groups that
host the sender:
drop gatewaysender mysender;
DROP FUNCTION
Drop the specified function.
Syntax
DROP FUNCTION [ IF EXISTS ] function-name
Description
This statement is valid only if there is exactly one function instance with the function-name in the schema.
Include the IF EXISTS clause to execute the statement only if the specified function exists in SQLFire.
The identified function can have any number of parameters defined for it. If no function with the indicated name
in the named or implied schema, an error (SQLSTATE 42704) occurs. An error also occurs more than one
specific instance of the function exists in the named or implied schema.
DROP INDEX
Drop the specified index.
519
SQL Language Reference