Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

up vote 5 down vote accepted

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

METHOD #1

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=.

METHOD #2

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

SELECT engine FROM INFORMATION_SCHEMA.TABLES
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

 
discard

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.