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 vote192 views1 answer
Opensuse stop MySQL
SQL
0 vote363 views1 answer
Mysql delete entire row on condition
SQL
0 vote201 views1 answer
Sauvegarde complète my sql
SQL
5 votes244 views1 answer
How to check port number for postgresql
SQL
3 votes212 views1 answer
Select sequence oracle
SQL
0 vote207 views1 answer
Value of sold product using having and group by in sql
SQL
0 vote214 views1 answer
On delete set default
SQL
21 votes207 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
0 vote219 views1 answer
Sql out file formate
SQL
0 vote333 views1 answer
Mysql update all record removing 2 hours from column
SQL