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

2 votes290 views2 answers
Postgres drop column if exists
SQL
0 vote268 views1 answer
Sql query to select records entered in last 24 hours
SQL
3 votes263 views1 answer
Search for column name in psql
SQL
0 vote329 views1 answer
How to find unique element in sql
SQL
1 vote233 views1 answer
Oracle boolean to varchar
SQL
11 votes284 views1 answer
Mysql order by two columns priority
SQL
0 vote263 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
11 votes249 views1 answer
Reset identity sql server
SQL
1 vote288 views1 answer
Mysql check string don't have number
SQL
3 votes298 views2 answers
Order by postgresql
SQL