sysobjects

Transact-SQL Reference

Transact-SQL Reference

sysobjects

Contains one row for each object (constraint, default, log, rule, stored procedure, and so on) created within a database. In tempdb only, this table includes a row for each temporary object.

Column name Data type Description
name sysname Object name.
Id int Object identification number.
xtype char(2) Object type. Can be one of these object types:

C = CHECK constraint
D = Default or DEFAULT constraint
F = FOREIGN KEY constraint
L = Log
FN = Scalar function
IF = Inlined table-function
P = Stored procedure
PK = PRIMARY KEY constraint (type is K)
RF = Replication filter stored procedure
S = System table
TF = Table function
TR = Trigger
U = User table
UQ = UNIQUE constraint (type is K)
V = View
X = Extended stored procedure

uid smallint User ID of owner object.
info smallint Reserved. For internal use only.
status int Reserved. For internal use only.
base_schema_
ver
int Reserved. For internal use only.
replinfo int Reserved. For use by replication.
parent_obj int Object identification number of parent object (for example, the table ID if a trigger or constraint).
crdate datetime Date the object was created.
ftcatid smallint Identifier of the full-text catalog for all user tables registered for full-text indexing, and 0 for all user tables not registered.
schema_ver int Version number that is incremented every time the schema for a table changes.
stats_schema_
ver
int Reserved. For internal use only.
type char(2) Object type. Can be one of these values:

C = CHECK constraint
D = Default or DEFAULT constraint
F = FOREIGN KEY constraint
FN = Scalar function
IF = Inlined table-function
K = PRIMARY KEY or UNIQUE constraint
L = Log
P = Stored procedure
R = Rule
RF = Replication filter stored procedure
S = System table
TF = Table function
TR = Trigger
U = User table
V = View
X = Extended stored procedure

userstat smallint Reserved.
sysstat smallint Internal status information.
indexdel smallint Reserved.
refdate datetime Reserved for future use.
version int Reserved for future use.
deltrig int Reserved.
instrig int Reserved.
updtrig int Reserved.
seltrig int Reserved.
category int Used for publication, constraints, and identity.
cache smallint Reserved.