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 vote226 views1 answer
Systemverilog unique constraint unique values
SQL
0 vote193 views1 answer
Import csv to mysql
SQL
0 vote230 views1 answer
Oracle index hint
SQL
1 vote221 views1 answer
Mysql history command
SQL
0 vote253 views2 answers
Replace null with 0 in sql
SQL
0 vote245 views2 answers
Reseed sql identity
SQL
0 vote257 views1 answer
Change date format in oracle query
SQL
1 vote245 views1 answer
Oracle enable job
SQL
2 votes250 views2 answers
Storing timezones in postgres
SQL
0 vote239 views3 answers
Java hide mysql login credentials
SQL