Object Information

--list all the tables         
SELECT name AS [Tables] FROM sys.objects WHERE OBJECTPROPERTY(object_id, 'isUserTable')<>0
--list all the Scalar functions
SELECT name AS [Scalar functions] FROM sys.objects WHERE OBJECTPROPERTY(object_id, 'IsScalarFunction')<>0
--list all the Table Functions
SELECT name AS [Table Functions] FROM sys.objects WHERE OBJECTPROPERTY(object_id, 'IsTableFunction')<>0
--list all the Procedures
SELECT name AS [Procedures] FROM sys.objects WHERE OBJECTPROPERTY(object_id, 'IsProcedure')<>0
--list all the Triggers
SELECT name AS [Triggers] FROM sys.objects WHERE OBJECTPROPERTY(object_id, 'IsTrigger')<>0

Source: red-gate.com

Similar codes

5 votes209 views2 answers
Postgresql add not null constraint
SQL
0 vote181 views2 answers
Sql query for getting details by id
SQL
24 votes190 views5 answers
Import dump mysql
SQL
1 vote205 views1 answer
Oracle sql pad left zeros
SQL
0 vote172 views1 answer
Sql transact create cursor with dynamic tables
SQL
0 vote176 views1 answer
Dns slave zone convert
SQL
24 votes180 views6 answers
Replace mysql
SQL
4 votes184 views1 answer
Describe table mysql
SQL
6 votes176 views5 answers
Alter table oracle
SQL
8 votes173 views1 answer
Alter tablespace add datafile
SQL