DROP TYPE Examples | Teradata Database - DROP TYPE Examples - Teradata Database

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Teradata Database
Release Number
20.00
Published
June 2025
ft:locale
en-US
ft:lastEdition
2026-09-23
dita:mapPath
mbm1747160743883.ditamap
dita:ditavalPath
jlp1749501702948.ditaval
dita:id
mdr1472255012272
lifecycle
latest

Example: Dropping the Definition of a UDT 1

This example drops the definition of the UDT named employee.

     DROP TYPE SYSUDTLIB.employee;

Example: Dropping the Definition of a UDT 2

This example drops the definition of the UDT named circle.

     DROP TYPE SYSUDTLIB.circle;