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

1 vote255 views1 answer
How to run sql script
SQL
7 votes342 views2 answers
MySQL IF without else
SQL
11 votes293 views2 answers
Having keyword sql
SQL
0 vote308 views1 answer
Soql user profile
SQL
3 votes299 views1 answer
Make a field auto_increment mysql
SQL
0 vote328 views1 answer
What does leave do in mysql
SQL
0 vote359 views1 answer
How to check rollback status in oracle
SQL
0 vote304 views1 answer
Mysql pv progres
SQL
0 vote326 views2 answers
Advantages of stored procedures sql
SQL
5 votes341 views4 answers
Upload database mysql command line
SQL