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