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 P = Stored procedure PK = PRIMARY KEY constraint (type is K) RF = Replication filter stored procedure S = System table 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 | Count of changes in schema of a given object (incremented if a rule or default is added). |
| 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 | Version number of the statistics. |
| type | char(2) | Object type. Can be one of these values: C = CHECK constraint D = Default or DEFAULT constraint F = FOREIGN KEY constraint K = PRIMARY KEY or UNIQUE constraint L = Log P = Stored procedure R = Rule RF = Replication filter stored procedure S = System table TR = Trigger U = User table V = View X = Extended stored procedure |
| userstat | smallint | Reserved. |
| sysstat | smallint | Internal status information. |
| indexdel | smallint | Index delete count (incremented if an index is deleted). |
| 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. |