Sysobjects table and mssqlsysobjects table in mssql

Sysobjects table and mssqlsysobjects table in mssql

The database (constraints, default values, logs, rules, stored procedures, etc.) can be found in the sysobjects table.

Column name	Data Type	Description
Name	Sysname	Object Name.
Id	Int	Object ID number.
Xtype	Char (2)	Object type. It can be one of the following object types: C = CHECK Constraints D = DEFAULT value or DEFAULT Constraint F = foreign key constraint L = Log FN = scalar function IF = embedded table functions P = Stored Procedure PK = primary key constraint (type: K) RF = copy and filter the Stored Procedure S = system table TF = table functions TR = trigger U = User table UQ = UNIQUE constraint (type is K) V = View X = Extended Stored Procedure
Uid	Smallint	User ID of the owner object.
Info	Smallint	Retained. For internal use only.
Status	Int	Retained. For internal use only.
Base_schema _ Ver	Int	Retained. For internal use only.
Replinfo	Int	Retained. For replication.
Parent_obj	Int	ID of the parent object (for example, this ID is the table ID for triggers or constraints ).
Crdate	Datetime	Object creation date.
Ftcatid	Smallint	The full-text directory identifier of all user tables registered for the full-text index. The value is 0 for all user tables not registered.
Schema_ver	Int	Version number, which is added each time the schema of the table is changed.
Stats_schema _ Ver	Int	Retained. For internal use only.
Type	Char (2)	Object type. It can be one of the following values: C = CHECK Constraints D = DEFAULT value or DEFAULT Constraint F = foreign key constraint FN = scalar function IF = embedded table functions K = primary key or UNIQUE constraint L = Log P = Stored Procedure R = rule RF = copy and filter the Stored Procedure S = system table TF = table functions TR = trigger U = User table V = View X = Extended Stored Procedure
Userstat	Smallint	Retained.
Sysstat	Smallint	Internal status information.
Indexdel	Smallint	Retained.
Refdate	Datetime	For future use.
Version	Int	For future use.
Deltrig	Int	Retained.
Instrig	Int	Retained.
Updtrig	Int	Retained.
Seltrig	Int	Retained.
Category	Int	Used for publishing, binding, and identification.
Cache	Smallint	Retained.