Syntax:
SHOW [STORAGE] ENGINES

SHOW ENGINES displays status information about the the server's storage
engines. This is particularly useful for checking whether a storage
engine is supported, or to see what the default engine is. This
statement is implemented in MySQL 4.1.2. SHOW TABLE TYPES is a
deprecated synonym.
