Skip to content

Instantly share code, notes, and snippets.

@sarahman

sarahman/list-all-the-mysql-tables.sql

Created September 7, 2020 20:15
Show Gist options
  • Save sarahman/5a218907fbc992ca87229b1aca85b412 to your computer and use it in GitHub Desktop.
Save sarahman/5a218907fbc992ca87229b1aca85b412 to your computer and use it in GitHub Desktop.
Download ZIP
List all the Mysql tables
Raw
list-all-the-mysql-tables.sql
SELECT * FROM `information_schema`.`tables`
WHERE `table_schema` = '<your_database_name>';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment