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 vote174 views1 answer
Traccar mysql
SQL
0 vote183 views1 answer
Sql use with to get value counts and percentages
SQL
0 vote160 views1 answer
Cross apply top for each row t1
SQL
1 vote157 views1 answer
Data type and their numeric form
SQL
1 vote207 views1 answer
Sql where max date
SQL
32 votes173 views6 answers
Insert into values select
SQL
0 vote152 views1 answer
Difference between cross apply and inner join
SQL
0 vote165 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
1 vote170 views2 answers
Sql where keyword
SQL
13 votes162 views6 answers
Mysql update from select
SQL