Dropping a user-defined datatype

To drop a user-defined datatype, execute sp_droptype:

sp_droptype typename

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