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 vote134 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
2 votes147 views2 answers
Insert all in sql
SQL
7 votes143 views2 answers
MySQL IF without else
SQL
2 votes135 views2 answers
Mysql all columns
SQL
1 vote150 views3 answers
How to truncate table with foreign key constraint
SQL
12 votes131 views4 answers
SQL Where
SQL
7 votes155 views3 answers
Sql server reset auto increment
SQL
0 vote144 views1 answer
Show tables in cassandra cql
SQL
1 vote146 views1 answer
Sample in sql
SQL
4 votes88 views1 answer
Generate class from sql table c#
SQL