내보내기(0) 인쇄
모두 확장
EN
이 콘텐츠는 한국어로 제공되지 않아 영어 버전으로 표시됩니다.

sysobjects

SQL Server 2000

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.

이 정보가 도움이 되었습니까?
(1500자 남음)
의견을 주셔서 감사합니다.
Microsoft는 MSDN 웹 사이트에 대한 귀하의 의견을 이해하기 위해 온라인 설문 조사를 진행하고 있습니다. 참여하도록 선택하시면 MSDN 웹 사이트에서 나가실 때 온라인 설문 조사가 표시됩니다.

참여하시겠습니까?
표시:
© 2014 Microsoft