15.10 - DROP TYPE - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Release Date
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
Language
English (United States)

Purpose

Drops the definition for the 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.

Required Privileges

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

Syntax