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 vote117 views1 answer
Neo4j command to run script file
SQL
0 vote118 views1 answer
Gcloud sql instance list
SQL
0 vote98 views2 answers
Postgresql create role
SQL
0 vote104 views1 answer
Connect to nginx server mysql remotly
SQL
33 votes98 views2 answers
Postgres how to add field created at
SQL
6 votes102 views2 answers
Mysql execute file
SQL
0 vote154 views1 answer
Parent and child link in mysql
SQL
0 vote112 views1 answer
Normalization in database
SQL
0 vote113 views1 answer
Ffeathers express mysql application users login
SQL
11 votes110 views2 answers
Oracle saurce code
SQL