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 vote336 views1 answer
How to delete python anywhere mysql database
SQL
0 vote308 views1 answer
How to count with except in psql
SQL
0 vote319 views1 answer
Set mysql socket file docker windows
SQL
0 vote334 views1 answer
Create function in microsoft sql server
SQL
1 vote340 views1 answer
Hackerrank sql test solutions
SQL
4 votes321 views2 answers
Postgresql reset sequence
SQL
0 vote359 views1 answer
Disable database droping sql
SQL
0 vote334 views4 answers
Postgresql between month
SQL
0 vote308 views1 answer
Mysql xampp reset root password
SQL
0 vote391 views1 answer
How to add auto increment primary key
SQL