Deletes a user-defined datatype from systypes.
sp_droptype typename
where
The typename user-defined datatype cannot be dropped if tables or other database objects reference it.
This example drops the user-defined datatype named birthday.
sp_droptype birthday
Execute permission defaults to the database owner and the datatype owner.
syscolumns, sysobjects, systypes, sysusers
| sp_addtype | sp_rename |