Instantly view the innodb row formats of tables so you can change them to another format


« Back to overview

COMPACT row format has it's disadvantages. If you want to create a migration, it might be useful to get a list of all the tables with a given row format.

The query below shows the InnoDB row formats and file format of your tables, limited to the compact row format.
Adjust the query as needed with your db name or row_format restriction.


SELECT substring_index(NAME, '/', -1) AS table_name, ROW_FORMAT AS row_format, FILE_FORMAT AS file_format FROM  information_schema.`INNODB_SYS_TABLES` 
WHERE 
ROW_FORMAT='compact'
AND
NAME LIKE 'YOURDBNAME/%'
ORDER BY NAME ASC