Skip to content

Instantly share code, notes, and snippets.

@tompazourek

tompazourek/count_tables.sql

Created October 24, 2017 13:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tompazourek/dfc14fd6aeb5e41242a4348511dfa1cc to your computer and use it in GitHub Desktop.
Save tompazourek/dfc14fd6aeb5e41242a4348511dfa1cc to your computer and use it in GitHub Desktop.
Download ZIP
Count number of tables in MS SQL database
Raw
count_tables.sql
SELECT COUNT(*) AS [TableCount] FROM [information_schema].[tables] WHERE [table_type] = 'BASE TABLE'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment