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

-1 vote182 views5 answers
Left join sql
SQL
0 vote128 views1 answer
How to write if case in select query in select statement
SQL
0 vote136 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
0 vote121 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
6 votes137 views1 answer
T-sql test if table exists
SQL
0 vote135 views1 answer
Mysql foreach insert
SQL
10 votes81 views1 answer
Oracle view dependencies
SQL
0 vote141 views1 answer
Can you write relational algebra into sql queries
SQL
1 vote131 views2 answers
T-sql random number for each row
SQL
0 vote132 views1 answer
What does leave do in mysql
SQL