MS SQL queries

getStoredProcedures.sql

/** https://stackoverflow.com/questions/219434/query-to-list-all-stored-procedures **/
select * 
  from DatabaseName.information_schema.routines 
 where routine_type = 'PROCEDURE'

getTables.sql

/** https://stackoverflow.com/questions/175415/how-do-i-get-list-of-all-tables-in-a-database-using-tsql **/
SELECT TABLE_NAME FROM <DATABASE_NAME>.INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'

getViews.sql

/** https://stackoverflow.com/questions/2903262/sql-query-to-list-all-views-in-an-sql-server-2005-database **/
SELECT * FROM sys.views