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 vote177 views1 answer
Postgresql pass array in function
SQL
11 votes548 views4 answers
Reset identity column values in sql server
SQL
0 vote168 views2 answers
How to find sql server agent jobs related to a database
SQL
1 vote175 views1 answer
Cross schema query oracle 2 users
SQL
9 votes201 views3 answers
Pyodbc connect to sql server
SQL
42 votes216 views6 answers
Rename table sql server
SQL
16 votes192 views6 answers
Mysql find duplicates in same table
SQL
4 votes161 views1 answer
To date oracle with time
SQL
3 votes158 views1 answer
Pl sql check if variable is empty
SQL
0 vote177 views1 answer
Mysql calculated column
SQL