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 vote252 views1 answer
Oracle apex prevent initial load
SQL
0 vote266 views1 answer
Mariadb disable foreign key checks
SQL
0 vote261 views1 answer
Mysql DDL
SQL
0 vote272 views1 answer
Create table database in psql
SQL
1 vote277 views1 answer
Customer using hdfc bank sql query
SQL
0 vote264 views1 answer
Frename oracle
SQL
1 vote251 views1 answer
Trigger in postgresql to change incoming entry
SQL
6 votes249 views1 answer
Oracle desc table primary key
SQL
0 vote244 views1 answer
Add alternate add column sql
SQL
8 votes268 views10 answers
Sql
SQL