DROP COMMAND
Removes
a stored command from the database.
SYNTAX
| command_name |
Name
of the stored command you want to remove from the database. |
DESCRIPTION
The DROP
COMMAND command removes an existing stored command from the database.
To execute the DROP COMMAND command, you must be the stored command owner,
or have DBA or SYSADM security privileges.
A stored
command is an SQL data-manipulation statement that is compiled and permanently
stored in the database in executable format. This allows you to repeatedly
execute the stored command without waiting for DBMaker to compile and
optimize the command each time you use it. Stored commands are similar
to stored procedures, except they can only contain a single command and
cannot contain program logic.
If you drop
a table or a column that is referenced by a stored command, alter a table
and modify the column definition, or alter a table and add a column using
the BEFORE and AFTER keywords, the stored command becomes invalid and
cannot be used again. Altering a table and adding a column without using
the BEFORE and AFTER keywords will have no impact on a stored command.
You can drop an invalid stored command to remove it from the database.
EXAMPLE
The following
example removes the stored command named sc1 from the database.
RELATED COMMANDS
<
DISCONNECT | Contents
| DROP DOMAIN >
|
