MySQL Information Schema  /  The INFORMATION_SCHEMA ENGINES Table

Chapter 19 The INFORMATION_SCHEMA ENGINES Table

The ENGINES table provides information about storage engines.

INFORMATION_SCHEMA Name SHOW Name Remarks
ENGINE Engine MySQL extension
SUPPORT Support MySQL extension
COMMENT Comment MySQL extension
TRANSACTIONS Transactions MySQL extension
XA XA MySQL extension
SAVEPOINTS Savepoints MySQL extension

Notes:

  • The ENGINES table is a nonstandard table. Its contents correspond to the columns of the SHOW ENGINES statement. For descriptions of its columns, see SHOW ENGINES Syntax.

See also SHOW ENGINES Syntax.


User Comments
Sign Up Login You must be logged in to post a comment.