Object Type:
AF = the polymerization function (CLR)
C = CHECK constraint
D = DEFAULT (constraint or stand-alone)
F = FOREIGN KEY constraint
PK = PRIMARY KEY constraint
P = SQL stored procedures
PC = assembly (CLR) stored procedure
Fn = SQL scalar function
FS = assembly (CLR) scalar function
FT = assembly (CLR) table-valued function
R = Rule (old-style, stand-alone)
RF = Replication filter process
SN = synonyms
SQ = Service queue
TA = assembly (CLR) DML trigger
TR = SQL DML trigger
IF = SQL inline table-valued function
TF = SQL table-valued function
U = Table (user-defined type)
UQ = UNIQUE constraint
V = view
X = Extended stored procedure
IT = Internal table
————————————————– ————————
xtype char (2) object type. Can be in one of the following object types:
C = CHECK constraint
D = default or DEFAULT constraint
F = FOREIGN KEY constraint
L = log
FN = scalar function
IF = inline table function
P = the stored procedure
PK = PRIMARY KEY constraint (type K)
RF = Replication filter stored procedure
S = system table
TF = Table function
TR = Triggers
U = User table
UQ = UNIQUE constraint (type is K)
V = view
X = Extended stored procedure
————————————————– —————-
Type char (2) object type. Can be one of the following values:
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 = the stored procedure
R = rule
RF = Replication filter stored procedure
S = system table
TF = Table function
TR = Triggers
U = User table
V = view
X = Extended stored procedure