Thursday, June 11, 2009

Distinct xtype values in sysobjects

xtype values in sysobjects
This is a list of all of the possible values for the xtype column in the sysobjects table of a SQL Server database:
C - CHECK constraint
D - Default or DEFAULT constraint
F - FOREIGN KEY constraint
L - Log
P - Stored procedure
PK - PRIMARY KEY constraint
RF - Replication filter stored procedure
S - System table
TR - Trigger
U - User table
UQ - UNIQUE constraint
V - View
X - Extended stored procedure

No comments: