(Component Integration Services only) Deletes the external storage mapping provided for a local object.
sp_dropobjectdef tablename
has the form dbname.owner.object, where:
dbname is the name of the database containing the object whose storage location you are dropping. dbname is optional; if present, it must be the current database, and the owner or a placeholder is required.
owner is the name of the owner of the object whose storage location you are dropping. owner is optional; it is required if dbname is specified.
object is the name of the local table for which external storage mapping is to be dropped.
Deletes the entry from sysattributes that provided the external storage mapping for a table known to the server as the colleges table in database personnel:
sp_dropobjectdef "personnel.dbo.colleges"
Deletes the entry from sysattributes that provided the external storage mapping for the andrea.fishbone object, where andrea is the owner and the local table name is fishbone:
sp_dropobjectdef "andrea.fishbone"
sp_dropobjectdef deletes the external storage mapping provided for a local object. It replaces sp_droptabledef.
Use sp_dropobjectdef after dropping a remote table with drop table.
Dropping a table does not remove the mapping information from the sysattributes table if it was added using sp_addobjectdef. It must be explicitly removed using sp_dropobjectdef.
The tablename can be in any of these forms:
object
owner.object
dbname..object
dbname.owner.object
The permission checks for sp_dropobjectdef differ based on your granular permissions settings.
Granular permissions enabled |
With granular permissions enabled, you must be the object owner or a user with drop any table privilege. |
Granular permissions disabled |
With granular permissions disabled, you must be the object owner, the database owner, or a user with sa_role. |
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 |
|
Commands create existing table, create table, drop table
System procedures sp_addobjectdef
