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 vote157 views3 answers
Sql delete all except
SQL
0 vote151 views1 answer
Oracle procedure chain step
SQL
0 vote167 views1 answer
Sql statement show all emails with dome
SQL
0 vote144 views6 answers
Unique key in sql
SQL
23 votes151 views4 answers
How to show all users in mysql
SQL
3 votes187 views2 answers
@sqlresultsetmapping
SQL
5 votes163 views4 answers
Start postgres server
SQL
5 votes166 views1 answer
How to check port number for postgresql
SQL
0 vote147 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
2 votes157 views2 answers
Create empty table from existing table
SQL