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 vote135 views2 answers
Show slave status mysql
SQL
0 vote232 views1 answer
Add user mysql wordpress
SQL
12 votes156 views6 answers
Between in sql
SQL
0 vote204 views1 answer
Ora 00001 error catch plsql
SQL
1 vote165 views1 answer
Mysql dump specific tables
SQL
0 vote152 views2 answers
Sql query for getting details by id
SQL
2 votes173 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
0 vote175 views1 answer
Liquibase update row
SQL
0 vote163 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
0 vote162 views1 answer
Sql convert float to string
SQL