Dropping a user-defined datatype

Use sp_droptype to remove a user-defined datatype from a database.

You cannot drop a datatype that is already in use in a table.