Accumulate common SQL Server statements

1. query database tables

Select * From sysobjects where (xtype = 'U ')
 
C = check Constraints
D = default value or default Constraint
F = foreign key constraint
L = Log
Fn = scalar function
If = embedded table functions
P = Stored Procedure
PK = primary key constraint (type: K)
Rf = copy and filter the Stored Procedure
S = system table
TF = table functions
Tr = trigger
U = User table
Uq = unique constraint (type is K)
V = View
X = Extended Stored Procedure

Query the number of columns in a table:

Select * From syscolumns where id = object_id ('t1 ')