Skip to content

Instantly share code, notes, and snippets.

@jeffreyroberts

jeffreyroberts/mysql_count_tables_in_db.sql

Created September 17, 2013 04:25
Show Gist options
  • Save jeffreyroberts/6590065 to your computer and use it in GitHub Desktop.
Save jeffreyroberts/6590065 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL - Count number of tables in a database
Raw
mysql_count_tables_in_db.sql
SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = '<database_name>';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment