Deletes an alias data type from systypes.
Transact-SQL Syntax Conventions
sp_droptype [ @typename = ] 'type'
Is the name of an alias data type that you own. type is sysname, with no default.
None
The type alias data type cannot be dropped if tables or other database objects reference it.
Requires membership in the db_owner fixed database role or the db_ddladmin fixed database role.
0 (success) or 1 (failure)
The following example drops the alias data type birthday.
birthday
USE master; GO EXEC sp_droptype 'birthday'; GO
