sys.sysobjects type, xtype

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