attebury · November 14, 2018 17:17
diff --git a/getStoredProcedures.sql b/getStoredProcedures.sql
 /** https://stackoverflow.com/questions/219434/query-to-list-all-stored-procedures **/
 select * 
  from DatabaseName.information_schema.routines 
 where routine_type = 'PROCEDURE'
diff --git a/getTables.sql b/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'
diff --git a/getViews.sql b/getViews.sql
 /** https://stackoverflow.com/questions/2903262/sql-query-to-list-all-views-in-an-sql-server-2005-database **/
 SELECT * FROM sys.views
	/ https://stackoverflow.com/questions/219434/query-to-list-all-stored-procedures /
	select *
	from DatabaseName.information_schema.routines
	where routine_type = 'PROCEDURE'
	/ 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'
	/ https://stackoverflow.com/questions/2903262/sql-query-to-list-all-views-in-an-sql-server-2005-database /
	SELECT * FROM sys.views