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

1 vote120 views1 answer
Show table columns
SQL
0 vote136 views1 answer
Sql server synonym
SQL
5 votes133 views1 answer
Commentaire table oracle
SQL
1 vote126 views1 answer
Python escape mysql
SQL
0 vote132 views1 answer
Oracle execute package dblink
SQL
1 vote154 views1 answer
Ora-01109 database not open in oracle 19c
SQL
0 vote80 views1 answer
Get all stored procedures in sql server
SQL
1 vote196 views1 answer
Truncate table in postgresql and reset id
SQL
1 vote121 views1 answer
Mysql select row max date
SQL
0 vote123 views1 answer
Java sql connection
SQL