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 vote333 views1 answer
Mysql show foreign keys column
SQL
0 vote353 views1 answer
On sql table data exists
SQL
1 vote354 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
0 vote324 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
0 vote346 views1 answer
Oracle allow space to user
SQL
0 vote369 views1 answer
SQL check if record exist
SQL
0 vote355 views1 answer
To_date sql
SQL
-2 votes335 views1 answer
Create trigger syntax
SQL
10 votes324 views2 answers
Mysql select timestamp group by day
SQL
11 votes372 views3 answers
How to get last row of table in sql
SQL