Skip to content

Instantly share code, notes, and snippets.

@mrpatrick

mrpatrick/table_names_by_engine.sql

Created October 19, 2015 17:50
Show Gist options
  • Save mrpatrick/5c5f02ac2f7cc17ef5dd to your computer and use it in GitHub Desktop.
Save mrpatrick/5c5f02ac2f7cc17ef5dd to your computer and use it in GitHub Desktop.
Download ZIP
show table names by engine
Raw
table_names_by_engine.sql
SELECT table_name, engine FROM INFORMATION_SCHEMA.TABLES order by engine;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment