Dropping a user-defined datatype

Use sp_droptype to drop a user-defined datatype. See the Reference Manual: Procedures.

NoteYou cannot drop a datatype that is in use in any table.