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 vote131 views1 answer
Find how many table doesn't contain column in mysql
SQL
0 vote146 views1 answer
Apt install sql server
SQL
5 votes159 views2 answers
Postgresql insert select
SQL
0 vote132 views1 answer
Sql view index
SQL
10 votes139 views1 answer
Oracle view dependencies
SQL
0 vote171 views1 answer
Sql create and grant user access to database
SQL
1 vote174 views1 answer
Sql server if exists update else insert
SQL
0 vote136 views1 answer
How to reset AI in sql
SQL
3 votes146 views2 answers
Monthname sql
SQL
0 vote140 views1 answer
Postpresql relation not found
SQL