1.0

Example
This 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 function-name
Description
This statement is valid only if there is exactly one function instance with the function-name in the schema. 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) will occur. An error will also occur if there is more
than one specific instance of the function in the named or implied schema.
DROP INDEX
Drop the specified index.
Syntax
DROP INDEX index-name
Description
Drops the index in the given schema (or current schema if none is provided).
DROP PROCEDURE
Drop the specified procedure.
Syntax
DROP PROCEDURE procedure-name
Description
Drops the specified procedure. This statement is valid only if there is exactly one procedure instance with the
procedure-name in the schema. The identified procedure can have any number of parameters defined for it. If
no procedure with the indicated name in the named or implied schema, an error (SQLSTATE 42704) will occur.
An error will also occur if there is more than one specific instance of the procedure in the named or implied
schema.
DROP SCHEMA
Drop the specified schema.
Syntax
DROP SCHEMA schema-name RESTRICT
Description
The RESTRICT keyword enforces the rule that no objects can be defined in the specified schema for the schema
to be deleted from the database. The RESTRICT keyword is required.
vFabric SQLFire User's Guide476
vFabric SQLFire Reference