Drops a user-defined datatype.
sp_droptype typename
is the name of a user-defined datatype that you own.
Drops the user-defined datatype named birthday:
sp_droptype birthday
Executing sp_droptype deletes a user-defined datatype from systypes.
A user-defined datatype cannot be dropped if it is referenced by tables or another database object.
The permission checks for sp_droptype differ based on your granular permissions settings.
Granular permissions enabled |
With granular permissions enabled, you must be the datatype owner or a user with manage database privilege. |
Granular permissions disabled |
With granular permissions disabled, you must be datatype owner or database owner. |
Values in event and extrainfo columns from the sysaudits table are:
Event |
Audit option |
Command or access audited |
Information in extrainfo |
|---|---|---|---|
38 |
exec_procedure |
Execution of a procedure |
|
Datatypes User-defined datatypes
System procedures sp_addtype, sp_rename
