sp_droptype (Transact-SQL)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Deletes an alias data type from systypes.

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

Topic link icon Transact-SQL Syntax Conventions

Syntax


sp_droptype [ @typename = ] 'type'  

Arguments

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

Return Code Type

0 (success) or 1 (failure)

Result Sets

None

Remarks

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

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.

Permissions

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

Examples

The following example drops the alias data type birthday.

Note

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

USE master;  
GO  
EXEC sp_droptype 'birthday';  
GO  

See Also

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