sp_droptype (Transact-SQL)


Deletes an alias data type from systypes.

Applies to: SQL Server (SQL Server 2008 through current version).

Topic link icon Transact-SQL Syntax Conventions

sp_droptype [ @typename = ] 'type'  

[ @typename=] 'type'
Is the name of an alias data type that you own. type is sysname, with no default.

0 (success) or 1 (failure)


The type alias data type cannot be dropped if tables or other database objects reference it.

System_CAPS_ICON_note.jpg Note

An alias data type cannot be dropped if the alias data type is used within a table definition or if a rule or default is bound to it.

Requires membership in the db_owner fixed database role or the db_ddladmin fixed database role.

The following example drops the alias data type birthday.

System_CAPS_ICON_note.jpg Note

This alias data type must already exist or this example returns an error message.

USE master;  
EXEC sp_droptype 'birthday';  

Database Engine Stored Procedures (Transact-SQL)
sp_addtype (Transact-SQL)
sp_rename (Transact-SQL)
System Stored Procedures (Transact-SQL)

Community Additions