luni, 25 august 2014

sysobjects table SQL Server

sysobjects table SQL Server

Contains one row for each database object (constraint, trigger , stored procedure, and so on).

Important coumns:

namesysnameObject name.
IdintObject identification number.
uidsmallintUser ID of owner object.
typechar(2)Object type:
C = CHECK constraint
D = Default or DEFAULT constraint
F = FOREIGN KEY constraint
FN = Scalar function
IF = Inline 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

Example:

select name,id,uid, type from sysobjects where name ='trg_asset_after_update'

name                             id                  uid type
trg_asset_after_update 1719155553 1    TR

Niciun comentariu:

Trimiteți un comentariu