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 vote140 views1 answer
Mysql return if it contains
SQL
19 votes153 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
0 vote153 views1 answer
Uncheck constraints and delete from table
SQL
2 votes152 views2 answers
How to check data type in sql server
SQL
0 vote138 views1 answer
Mysql master slave setup with keepalived
SQL
0 vote126 views1 answer
Mysql calculated column
SQL
1 vote170 views1 answer
Insert many to many sql
SQL
4 votes124 views2 answers
Sql server date now
SQL
0 vote95 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
8 votes131 views2 answers
Replace string value in sql
SQL