DROP DATATYPE statement

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.