To drop a user-defined datatype, execute:
sp_droptype typename
You cannot drop a datatype that is in use in any table.
View this book as PDF