Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

Create a new Page
Administration
File Management
Login/Logout
Your Profile

Other Wiki Sections

Software

PoweredBy

sysobjects System Table - SQL Server 2000

RSS
Modified on Fri, May 01, 2009, 11:01 AM by Administrator Categorized as SQL Server System Tables
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.

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.