SQL Server queries database information

 use dbnameselect  * from sysobjects WHERE (xtype =  " u   " ) Goxtype can be replaced with the following parameters --c = CHECK constraint --d =--f = FOREIGN KEY constraint --l = log--fn = scalar function --if = inline table function --p =  stored procedure --pk = PRIMARY KEY constraint (type K) --rf = copy filter stored procedure --s = system table --TF =  table function --tr = trigger --u =  user table --uq = UNIQUE constraint (type K) --v = view --x = extended stored Procedure 

SQL Server queries database information