Select * From sysobjects where (xtype = 'U ')
Select * From sysobjects where (xtype = 'U ')
Select * From sysobjects where (xtype = 'C ')
Select * From sysobjects where (xtype = 'D ')
Select * From sysobjects where (xtype = 'F ')
Select * From sysobjects where (xtype = 'l ')
Select * From sysobjects where (xtype = 'fn ')
Select * From sysobjects where (xtype = 'if ')
Select * From sysobjects where (xtype = 'P ')
Select * From sysobjects where (xtype = 'pk ')
Select * From sysobjects where (xtype = 'rf ')
Select * From sysobjects where (xtype ='s ')
Select * From sysobjects where (xtype = 'tr ')
Select * From sysobjects where (xtype = 'U ')
Select * From sysobjects where (xtype = 'uq ')
Select * From sysobjects where (xtype = 'V ')
Select * From sysobjects where (xtype = 'X ')
-- C = check Constraints
-- D = default value or default Constraint
-- F = foreign key constraint
-- L = log -- fn = scalar function
-- If = embedded Table Function
-- P = Stored Procedure
-- PK = primary key constraint (type: K)
-- Rf = copy and filter the Stored Procedure
-- S = system table
-- TF = Table Function
-- TR = trigger
-- U = User table
-- Uq = unique constraint (type is K)
-- V = View
-- X = Extended Stored Procedure