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

3 votes194 views2 answers
How to delete git repo locally
SQL
1 vote188 views1 answer
Mysql strict_trans_tables
SQL
0 vote187 views2 answers
Mysql insert into multiple tables
SQL
1 vote169 views1 answer
ERROR 1193 (HY000): Unknown system variable 'GTID_PURGED'
SQL
2 votes224 views1 answer
Mariadb json select
SQL
25 votes198 views4 answers
Import mysql dump command line
SQL
2 votes162 views1 answer
Update with join sql server
SQL
0 vote168 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
1 vote199 views1 answer
Oracle list data files
SQL
0 vote188 views1 answer
Sql server on mac m1
SQL