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

16 votes154 views1 answer
Sqlserver add column to table
SQL
0 vote180 views1 answer
Mysql export data with a where clause
SQL
0 vote152 views2 answers
Get all index postgres
SQL
0 vote160 views1 answer
Select even number id data from table
SQL
0 vote178 views1 answer
Oracle winter time change
SQL
0 vote181 views1 answer
Oracle chain step succeeded
SQL
21 votes126 views7 answers
Table drop if exist sql server
SQL
27 votes173 views6 answers
Set password mysql
SQL
0 vote165 views1 answer
How get data from database if id not found then search another column
SQL
0 vote156 views1 answer
Create a view in sqlite
SQL