Export (0) Print
Expand All
Expand Minimize

sp_droptype (Transact-SQL)

Deletes an alias data type from systypes.

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.

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.

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:
© 2014 Microsoft