Re: storage engine

[Sergio Andres De La Cruz Rodriguez]

Hi Dimitris:

A quick way would be to right click on the table name in the schema tree (to the left in the Workbench Query Editor) and select Send to SQL Editor -> Create Statement. This will show you the create statement for that table, that usually includes the storage engine that it uses.

Another solution would be to query it:

SELECT ENGINE
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'your_db'
AND TABLE_NAME = 'your_table'

Cheers,

Sergio A. de la Cruz Rodríguez
Software Developer
Oracle Corp.