DROP TABLE PROCEDURE

The DROP TABLE PROCEDURE data description statement deletes the definition of the referenced table procedure from the dictionary. It is also a CA IDMS extension of the SQL standard.

Authorization

To issue a DROP TABLE PROCEDURE statement, you must own or have the DROP privilege on the table procedure named in the statement.

Syntax

►►─── DROP TABLE PROCEDURE ─┬──────────────────┬─ table-procedure-identifier ─►
                            └── schema-name. ──┘

 ►────┬───────────┬───────────────────────────────────────────────────────────►◄
      └─ CASCADE ─┘

Parameters

table-procedure-identifier

Specifies the name of the table procedure to be dropped. Table-procedure-identifier must identify a table procedure defined in the dictionary.

schema-name

Identifies the schema associated with the specified table procedure. If you do not specify a schema-name, the default value is:

The current schema associated with your SQL session, if the statement is specified through the Command Facility or executed dynamically
The schema associated with the access module used at runtime, if the statement is embedded in an application program

CASCADE

Directs CA IDMS to delete any view definition that contains a reference to the table procedure, either directly or nested within some other view reference.

Example

The following DROP TABLE PROCEDURE statement removes the EMP.ORG table procedure from the SQL catalog.

   drop table procedure emp.org cascade

More Information

For more information about syntax for creating table procedures, see CREATE TABLE PROCEDURE.
For more information about defining and using table procedures, see Defining and Using Table Procedures.
For more information about coding the external routines which process procedure references, see Defining and Using Table Procedures.