DROP DATATYPE datatype-name

It is recommended that you use DROP DOMAIN rather than DROP DATATYPE, as DROP DOMAIN is the syntax used in the SQL/2008 standard. You cannot drop system-defined data types (such as MONEY or UNIQUEIDENTIFIERSTR) from a database.

Any user who owns the object, or has DBA authority, can execute the DROP DATATYPE statement.

Automatic commit. Clears the Results tab in the Results pane in Interactive SQL.

• DROP DOMAIN statement
• CREATE DOMAIN statement
• ALTER DOMAIN statement

Drop MyDatatype from the database. If the datatype does not exist, an error is returned.

DROP DATATYPE MyDatatype;