DROP CAST SQL Statement | Teradata Vantage - 17.05 - DROP CAST - 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 a cast definition for a UDT from the data dictionary.

You can also drop the system-generated casts for distinct UDTs. The system does not drop the associated external cast routine when you perform DROP CAST.

You should not drop a cast if it is referenced by a view, stored procedure, trigger, or macro. There are no restrictions on dropping a cast. The system always honors a DROP CAST request whether it is referenced by a view, stored procedure, trigger, or macro. However, after you drop a cast, any attempt to use a view, stored procedure, trigger, or macro that references the dropped cast returns an error to the requestor.

ANSI Compliance

This statement is ANSI SQL:2011 compliant.

Required Privileges

You must have either the UDTTYPE or the UDTMETHOD privilege on the SYSUDTLIB database to drop a user-defined cast for a UDT.