Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

sp_droptype (Transact-SQL)

 

Applies To: SQL Server 2014, SQL Server 2016 Preview

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_noteNote

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_noteNote

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

USE master;
GO
EXEC sp_droptype 'birthday';
GO
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft