Deleting SQL Objects

You can use the DROP statement to completely remove tables, indexes, views, and synonyms. This function obsoletes all definitions of the object in the CA Datacom Datadictionary, deletes it from the CA Datacom/DB Directory, and removes it from the schema. You cannot use the DROP statement to remove a schema. See Deleting a Schema.

Enter the DROP statement in the numbered area of an EDIT Source Member Panel. See How to Submit SQL Statements for the steps to obtain the panel and an explanation of the fields on the panel. See DROP for the syntax of the statement.

All application plans that reference the dropped object are marked invalid. In addition, any data stored in a table is deleted when it is dropped. You can run a CA Datacom Datadictionary Relationship Report to find out what plans are dependent on a table. See the CA Datacom Datadictionary Batch Reference Guide for information on running a Relationship Report.

When you drop an index, all versions of the index in all statuses are automatically obsoleted.
When you drop a table, all versions of the table in all statuses and all views and synonyms dependent on the table are automatically obsoleted.
When you drop a view, all views and synonyms dependent on the view are automatically obsoleted.
When you drop a synonym, only the synonym is obsoleted.

Note: The DROP statement is not processed, and you receive a -118 return code when the entity-occurrence definition of the index, table, view, or synonym you specify is protected with a password or a Lock Level 1 or 2 in CA Datacom Datadictionary. The error message also includes a CA Datacom Datadictionary Service Facility (DSF) return code. The DSF return codes are:

IPW for password protected
IOR for Lock Level 1 protected
NTF for Lock Level 2 protected

See Preliminary Information—Lock Levels and to CA Datacom Datadictionary documentation for more information on passwords and lock levels.

For information about the CA Datacom/DB implementation of DROP PROCEDURE and DROP TRIGGER/RULE, see Procedures and Triggers and Datadictionary Support for Triggers and Procedures.