Name

SHOW ENGINES

Synopsis

SHOW [STORAGE] ENGINES

This statement will list the table types or storage engines available for the version of MySQL running on the server. It will state which are disabled on the server and which are enabled, as well as which is the default type. It will also provide comments on each type. The STORAGE keyword is optional and has no effect on the results. This SQL statement replaces SHOW TABLE TYPES, which produced the same results, but is deprecated.

Get MySQL in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.