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

4 votes379 views2 answers
Truncate oracle
SQL
2 votes360 views1 answer
Grant revoke privileges to mysql username
SQL
0 vote358 views1 answer
Mysql bind-address default value
SQL
0 vote345 views1 answer
Create api project in visual studio 2019 and sql server
SQL
5 votes428 views3 answers
Create function in postgresql
SQL
0 vote353 views1 answer
We are intrested to work with your organization
SQL
-1 vote373 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
6 votes379 views1 answer
How to get the size of the database in postgresql
SQL
3 votes365 views2 answers
Oracle sql select all days between two dates except weekends
SQL
13 votes376 views1 answer
Sql join 3 tables on id
SQL