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

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 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; 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
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.