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

3 votes197 views1 answer
V$session not found in oracle
SQL
2 votes211 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
0 vote213 views1 answer
Edit shchima table in sql
SQL
0 vote213 views1 answer
In query in sql
SQL
0 vote202 views1 answer
Postgresql custom order by
SQL
8 votes180 views1 answer
Sql limit results returned
SQL
3 votes179 views4 answers
Stop MySQL
SQL
0 vote171 views1 answer
How to get employee having maximum experience in mysql
SQL
0 vote203 views1 answer
Nuget sqllite-net-pcl
SQL
-2 votes191 views1 answer
Create trigger syntax
SQL