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 vote244 views10 answers
John the ripper mysql
SQL
0 vote325 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
-1 vote257 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
1 vote270 views3 answers
Drop unique key constraint in sql server
SQL
0 vote239 views1 answer
Linux upload database to mysql
SQL
42 votes358 views6 answers
Rename table sql server
SQL
7 votes257 views3 answers
Sql get last inserted row
SQL
1 vote278 views1 answer
Setval pgsql
SQL
0 vote276 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
0 vote287 views4 answers
Restart MySQL
SQL