sp_helpobjectdef

(Component Integration Services only) Reports owners, objects, and type information for remote object definitions.

Syntax

sp_helpobjectdef [objname]

objname – is the name of the object as it is defined in the sysattributes table. The objname can be in any of the following forms:
- dbname.owner.object
- dbname..object
- owner.object
- object
dbname and owner are optional. object is required. If owner is not supplied, the owner defaults to the current user name. If dbname is supplied, it must be the current database, and owner must be supplied or marked with the placeholder dbname..object. Enclose a multipart objname in quotes.

Example 1 – Displays all remote object definitions in the current database:
```
sp_helpobjectdef
```
Example 2 – Displays remote object definitions for the tb1 table owned by the database owner:
```
sp_helpobjectdef "dbo.tb1"
```

If no objname is supplied, sp_helpobjectdef displays all remote object definitions.

A server name is not permitted in the objname parameter.

See also create table, create existing table, drop table in Reference Manual: Commands.

Any user can execute sp_helpobjectdef. Permission checks do not differ based on the granular permissions settings.

Values in event and extrainfo columns from the sysaudits table are:

Information	Values
Event	38
Audit option	exec_procedure
Command or access audited	Execution of a procedure
Information in `extrainfo`	Roles – Current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – All input parameters Proxy information – Original login name, if set proxy in effect