Sys types

"Type" columns of SysObjects table represent the different objects available in database (like Table,Trigger,Stored Procedures etc.). Below list explains the different values of "Type" columns.

C = CHECK constraint 
D = Default or DEFAULT constraint
F = FOREIGN KEY constraint 
FN = Scalar function
IF = Inlined 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