|
|
Find which tables use INNODB with MySQL - Mysql
|
Views : 278
|
|
Tagged in : Mysql
|
|
|
Report This Scrap as Inappropriate
We request you to choose the appropriate categroy and subcategory that suits your
objectionable concern about the scrap, So that our team can review and find out whether it violates our Guidelines or the
scrap is not suitable for all viewers.
|
The SQL to do this queries the INFORMATION_SCHEMA and is as follows:
SELECT table_schema, table_name
FROM INFORMATION_SCHEMA.TABLES
WHERE engine = 'innodb';
table_schema is the name of the database.
table_name is (obviously) the name of the table.
The above query will list the table names whose engine is innodb. |
|
By Rekha, On - 2010-01-28 |
|
|
|
