DROP TYPE

Remove an alias data type or user-defined type (CLR) from the current database.

Syntax
      DROP TYPE [schema.] type [ ; ]

Key
   type     Name of the type (alias or user-defined) to be dropped.

When a table is dropped, all associated triggers are automatically dropped.

Examples

DROP Type MyType;

"A chic type, a rough type, an odd type - but never a stereotype" - Jean-Michel Jarre

Related commands:

CREATE TYPE

Equivalent Oracle command:

DROP TYPE