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