Monday, June 28, 2010

[Code] Xtype definitions

'C' = CHECK constraint
'D' = Default or DEFAULT constraint
'F' = FOREIGN KEY constraint
'L' = Log
'FN' = Scalar function
'IF' = In-lined 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

No comments: