sys.sp_droptype

Description

Deletes an alias data type from The name of an alias data type that you own. , with no default. alias data type can’t be dropped if tables or other database objects reference it. An alias data type can’t be dropped if the alias data type is used within a table definition or if a rule or default is bound to it.

Syntax

sp_droptype [ @typename = ]
N
'typename'
[ ; ]

Remarks

Deletes an alias data type from

The name of an alias data type that you own.

, with no default.

(success) or

alias data type can’t be dropped if tables or other database objects reference it.

An alias data type can’t be dropped if the alias data type is used within a table definition

or if a rule or default is bound to it.

Examples

Example 1

birthday

Example 2

USE master
;
GO
EXECUTE sp_droptype
'birthday'
;
GO