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 vote194 views1 answer
Sql get number of days between two dates
SQL
1 vote157 views1 answer
Ms sql how to see active job current run time
SQL
0 vote200 views1 answer
Geopoint from json mysql function
SQL
0 vote228 views1 answer
Update sql sintax
SQL
1 vote194 views1 answer
Where database run
SQL
0 vote206 views2 answers
Collation in sql
SQL
0 vote195 views2 answers
How to find sql server agent jobs related to a database
SQL
1 vote185 views1 answer
Mysql check table exists
SQL
9 votes210 views5 answers
Laravel to sql
SQL
0 vote190 views1 answer
Drop a field in psql django
SQL