DROP PROCEDURE SQL Statement | Teradata Vantage - 17.05 - DROP PROCEDURE - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1144-175K
Language
English (United States)

Drops the definition for the specified procedure from the Data Dictionary and from the containing database or user.

When you drop a procedure, the system frees the disk space used by the dropped procedure and any fallback copy, removes any explicit access privileges on the object, and removes the metadata for the dropped object from the data dictionary.

ANSI Compliance

DROP PROCEDURE is ANSI SQL:2011-compliant.

Required Privileges

You must have the appropriate DROP privilege on the specified procedure.