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

5 votes106 views3 answers
Sql max value in column
SQL
8 votes62 views2 answers
Alter column name in mssql
SQL
0 vote117 views1 answer
Sql select min row
SQL
1 vote111 views1 answer
Pl sql create table from another table
SQL
2 votes116 views2 answers
Insert all in sql
SQL
20 votes112 views4 answers
Sqlite create table if not exists
SQL
2 votes117 views1 answer
Add default sql server
SQL
0 vote132 views1 answer
Suhaib
SQL
0 vote125 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL
2 votes114 views3 answers
How to get second highest salary in each department in sql
SQL