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 vote305 views1 answer
Postgresql delete limit
SQL
2 votes336 views1 answer
Pdo mysql insert
SQL
5 votes302 views1 answer
Sort order on two columns sql
SQL
0 vote277 views1 answer
Default column value in sql same as other column
SQL
0 vote294 views1 answer
Android sqlite get rows count
SQL
0 vote342 views2 answers
Clauses in mysql
SQL
0 vote276 views1 answer
How to get n result in sql
SQL
1 vote275 views1 answer
Create sample data postgresql
SQL
3 votes305 views1 answer
Oracle drop user
SQL
1 vote257 views1 answer
Foreign key in oracle sql developer
SQL