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 vote115 views1 answer
Mysql max number not returning correct value
SQL
1 vote125 views1 answer
Oracle compile schema
SQL
0 vote167 views1 answer
Sql select without column name
SQL
-2 votes124 views1 answer
How to open database
SQL
0 vote118 views1 answer
Mysql date only no time
SQL
0 vote114 views1 answer
Sql server delete records with specific date
SQL
0 vote121 views1 answer
Laravel eloquent get generated sql
SQL
0 vote84 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
0 vote122 views1 answer
Mysql Like(searching in the string)
SQL
-2 votes127 views1 answer
Mysql not empty
SQL