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 vote294 views1 answer
Denormalise SQL command
SQL
0 vote315 views1 answer
Drop domain postgresql
SQL
0 vote315 views1 answer
Implicit inner join table alias
SQL
0 vote326 views2 answers
Mysql update two tables at once
SQL
50 votes382 views6 answers
Install mysql on ubuntu
SQL
1 vote301 views1 answer
Xampp import sql file command line
SQL
4 votes344 views1 answer
Rename stored procedure in sql server
SQL
0 vote295 views1 answer
Opensuse start MySQL
SQL
1 vote285 views3 answers
String to int mysql
SQL
0 vote342 views1 answer
Cube oracle
SQL