15.10 - DROP TYPE - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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