Skip to content

Instantly share code, notes, and snippets.

@arshad115

arshad115/Useful SQL Queries.md

Created August 2, 2018 15:19
Show Gist options
  • Save arshad115/30f070d1830eb4fbaf32d694079cd522 to your computer and use it in GitHub Desktop.
Save arshad115/30f070d1830eb4fbaf32d694079cd522 to your computer and use it in GitHub Desktop.
Download ZIP
Useful SQL Queries
Raw
Useful SQL Queries.md

Collection of Useful SQL queries

/* Count Number Of Tables In A Database */
SELECT COUNT(*) AS TABLE_COUNT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'
 
/* Count Number Of Views In A Database */
SELECT COUNT(*) AS VIEW_COUNT FROM INFORMATION_SCHEMA.VIEWS
 
/* Count Number Of Stored Procedures In A Database */
SELECT COUNT(*) AS PROCEDURE_COUNT FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_TYPE = 'PROCEDURE'
 
/* Count Number Of Functions In A Database */
SELECT COUNT(*) AS FUNCTION_COUNT FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_TYPE = 'FUNCTION'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment