1. How to get list of stored procedures in a database
2. How to get list of tables in a database
3. How to get list of databases in a SQL server
SELECT NAME FROM SYS.ALL_OBJECTS WHERE type= 'P'
2. How to get list of tables in a database
SELECT * from sysobjects where type = 'U'
3. How to get list of databases in a SQL server
SELECT name, collation_name FROM sys.databases WHERE name NOT IN ('master', 'tempdb', 'model', 'msdb')