DROP PROCEDURE SQL Statement | VantageCloud Lake - DROP PROCEDURE - Teradata VantageCloud Lake

Lake - Working with SQL
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530
This statement is only supported on the Block File System on the primary cluster. It is not available for the Object File System.

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.