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 vote235 views1 answer
Sometimes i cant edit sql developer
SQL
0 vote235 views1 answer
Alter boolean column postgresql
SQL
-1 vote254 views1 answer
How to Activate the database
SQL
0 vote227 views1 answer
User defined variables in sql
SQL
0 vote239 views1 answer
Codeigniter 3 get best-selling products
SQL
0 vote237 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
0 vote233 views2 answers
How to create a table from another table in sql derby
SQL
29 votes221 views6 answers
Delete all rows from table mysql
SQL
1 vote231 views2 answers
Oracle 18c xe ORA-65096
SQL
0 vote236 views1 answer
Change magento database url usimg musql
SQL