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 vote362 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote284 views1 answer
Order by oracle
SQL
10 votes290 views5 answers
Between keyword in sql
SQL
0 vote304 views1 answer
C# get sql min date
SQL
0 vote289 views2 answers
How to display enum value sql server
SQL
0 vote294 views1 answer
Second Step in installing SQL workbench
SQL
0 vote295 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
1 vote279 views1 answer
Mysql show table character set
SQL
1 vote290 views1 answer
Convert varchar to int in sqlite
SQL
0 vote306 views1 answer
How to make case insensitive in sql
SQL