Drop a User-Defined Datatype

Use sp_droptype to drop a user-defined datatype.

See the Reference Manual: Procedures.

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