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

0 vote200 views1 answer
Get who is hired in february in sql
SQL
0 vote204 views2 answers
Sql join on comma separated field
SQL
3 votes140 views1 answer
How to get list of synonyms in oracle
SQL
0 vote256 views2 answers
Suse stop MySQL
SQL
0 vote183 views1 answer
Sqlite3 now
SQL
0 vote197 views2 answers
Sql searching via key word
SQL
4 votes298 views2 answers
Convert utc to est sql
SQL
2 votes204 views1 answer
How to make insert script from table in SQL server
SQL
0 vote204 views1 answer
Oracle create job if not exists
SQL
0 vote193 views1 answer
How to check xampp mysql password
SQL