Removes a datatype from the database.
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.
SQL/2008 Domain support is optional SQL language feature F251 in the SQL/2008 standard. The DROP DATATYPE statement is a vendor extension.
Drop MyDatatype from the database. If the data type does not exist, an error is returned.
DROP DATATYPE MyDatatype;