DROP TYPE SQL Statement | Teradata Vantage - DROP TYPE - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
ncd1596241368722.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

Drops the definition for a specified UDT.

Before you can drop a UDT definition, the UDT:

  • Cannot be directly or indirectly referenced by any database object in the system.
  • Cannot be used as the data type of a column in any table in any database in the system.
  • Cannot be an attribute of structured UDT.
  • Cannot be referenced by any user-defined cast, method, or UDF in any database in the system.
  • Cannot have an ordering or transform definition.
These prerequisites also apply to one-dimensional and multidimensional ARRAY and VARRAY types.

When you drop a UDT definition, the system also drops:

  • All methods associated with the specified UDT.
  • All external routines and libraries associated with the dropped methods.

ANSI Compliance

This statement is ANSI SQL:2011 compliant.

Required Privileges

You must have either the UDTTYPE privilege or the UDTMETHOD privilege on the SYSUDTLIB database to drop a UDT.