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

9 votes207 views2 answers
Sql limit order by
SQL
1 vote186 views1 answer
Enable mysql slow query log
SQL
2 votes234 views1 answer
Drop all foreign key constraints mysql
SQL
0 vote221 views1 answer
C# mysql data reader from two tables
SQL
1 vote228 views1 answer
Sql server loop over query
SQL
0 vote240 views1 answer
Command to give readonly access to a postgres sql user
SQL
0 vote210 views1 answer
Sqlite referential integrity
SQL
0 vote211 views1 answer
Sql server manager close connection
SQL
6 votes227 views2 answers
How to copy data in sql
SQL
6 votes227 views2 answers
Postgresql restore from dump
SQL