16.20 - DROP TYPE - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

Purpose

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.

Required Privileges

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

Syntax