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

40 votes433 views4 answers
PostgreSQL add column
SQL
1 vote344 views3 answers
Rename table snowflake
SQL
0 vote328 views1 answer
Can't connect to postgresql mac os
SQL
2 votes313 views1 answer
Match in sql server
SQL
4 votes1.1K views1 answer
Oracle show errors
SQL
0 vote338 views1 answer
Plpgsql raise notice
SQL
0 vote326 views1 answer
Sqlplus change user
SQL
3 votes285 views1 answer
Postgresql where current year
SQL
3 votes335 views4 answers
Stop MySQL
SQL
0 vote321 views1 answer
Recover deleted data from mysql database
SQL