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.
idmscu19
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