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 foreign table names mysql
SQL
7 votes211 views5 answers
Show details of table postgres
SQL
4 votes187 views2 answers
What is table in sql
SQL
1 vote212 views1 answer
Print all records of table in mysql
SQL
3 votes189 views1 answer
Difference sql vs mysql
SQL
0 vote211 views1 answer
Rename view mysql
SQL
0 vote212 views1 answer
Postgresql list extensions
SQL
0 vote226 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
1 vote230 views1 answer
Update substring in mysql
SQL
0 vote214 views1 answer
Select into table variable
SQL