Within the database (constraints, defaults, logs, rules, stored procedures, and so on) can be found in the sysobjects table.
| Column Name |
Data Type |
Description |
| name |
sysname |
object name. |
| Id |
int |
object identification number. |
| xtype |
char (2) |
object type. Can be one of the following types of objects: c = CHECK constraint D = default value, or DEFAULT constraint F = FOREIGN KEY constraint L = Log FN = Scalar function IF = inline table function P = stored procedure PK = PRIMARY KEY constraint (type is K) RF = copy Filter stored procedure S = system table TF = table function TR = Trigger U = User table UQ = UNIQUE constraint (type K) V = view X = extended stored procedure |
| uid |
smallint |
user ID of the owner object. |
| info |
smallint |
reserved. Internal use only. |
| status |
int |
reserved. Internal use only. |
base_schema_ ver |
int |
reserved. Internal use only. |
| replinfo |
int |
reserved. For replication use. |
| parent_obj |
int |
| crdate |
datetime |
The date the object was created. |
| ftcatid |
smallint |
full-text catalog identifier for all user tables registered for full-text indexing, or 0 for all user tables that are not registered. |
| schema_ver |
int |
version number, which is incremented each time the schema of the table changes. |
stats_schema_ ver |
int |
reserved. Internal use only. |
| type |
char (2) |
object type. It can be one of the following values: c = CHECK constraint D = default value or defaults constraint F = FOREIGN KEY constraint &nbs P FN = Scalar function IF = inline table function K = PRIMARY KEY or UNIQUE constraint L = log P = stored procedure R = rule RF = Copy Filter stored procedure S = System 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 later use. |
| version |
int |
reserved for later use. |
| deltrig |
int |
reserved. |
| instrig |
int |
reserved. |
| updtrig |
int |
reserved. |
| seltrig |
int |
reserved. |
| category |
int |
for publishing, constraints, and identification. |
| Cache |
smallint |
Keep.
|
sysobjects table in MSSQL