sysobjects


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
FN = Scalar function
IF = Inlined table-function
P = Stored procedure
PK = PRIMARY KEY constraint (type is K)
RF = Replication filter stored procedure
S = System table
TF = Table function
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
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.
(繼續閱讀...)
文章標籤

brucebin 發表在 痞客邦 留言(0) 人氣(97)