15.00 - DROP PROCEDURE - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

DROP PROCEDURE

DROP Processes for DROP PROCEDURE

The system pursues the following process to drop a procedure.

1 Sets an EXCLUSIVE lock on the procedure.

2 Frees the disk space used by the dropped procedure and any fallback copy.

3 Removes any explicit access privileges on the object.

4 Removes the metadata for the dropped object from the data dictionary.