sysobjects System Table - SQL Server 2000

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 nameData typeDescription
namesysnameObject name.
IdintObject identification number.
xtypechar(2)Object type. Can be one of these object types: 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
uidsmallintUser ID of owner object.
infosmallintReserved. For internal use only.
statusintReserved. For internal use only.
base_schema_verintReserved. For internal use only.
replinfointReserved. For use by replication.
parent_objintObject identification number of parent object (for example, the table ID if a trigger or constraint).
crdatedatetimeDate the object was created.
ftcatidsmallintIdentifier of the full-text catalog for all user tables registered for full-text indexing, and 0 for all user tables not registered.
schema_verintVersion number that is incremented every time the schema for a table changes.
stats_schema_verintReserved. For internal use only.
typechar(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.
userstatsmallintReserved.
sysstatsmallintInternal status information.
indexdelsmallintReserved.
refdatedatetimeReserved for future use.
versionintReserved for future use.
deltrigintReserved.
instrigintReserved.
updtrigintReserved.
seltrigintReserved.
categoryintUsed for publication, constraints, and identity.
cachesmallintReserved.