Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've just installed MySQL Workbench 5.2.39 and I'm currently viewing one of my databases through the 'Schema' panel in a 'SQL Editor' tab. I can see all of my database's tables under 'Tables', but no indication of what engine they use. Where can I find this information?

share|improve this question
up vote 6 down vote accepted

There are two ways to see the storage engine of a table


Step 01) Double Click on which Connection you want to open (Opens SQL Editor)

Step 02) Click on the Database

Step 03) Right Click on the Table (menu pops up)

Step 04) Click on Send to SQL Editor (menu appears sideways)

Step 05) Click Create Statement

You will see the CREATE TABLE SQL command. At the bottom of the Command is the part that says ENGINE=.


Another way to display the engine of a table is to query the INFORMATION_SCHEMA database

For a table mydb.mytable, run this to see the engine

WHERE table_schema='mydb' AND table_name='mytable';

Give it a Try !!!

share|improve this answer
Both methods work, but it seems like a glaring omission from the GUI to not mention somewhere the engine type! Compared to the previous MySQL Administrator Toolkit. – codinghands Apr 24 '12 at 14:14

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.