DROP MACRO SQL Statement | Teradata Vantage - 17.10 - DROP MACRO - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

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

Drops the definition for the specified macro from the dictionary.

The system frees the disk space used by the dropped macro 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

This statement is a Teradata extension to the ANSI SQL:2011 standard.

Required Privileges

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