Administrative SQL statements

Supported Administrative SQL statements

Xpand supports the following administrative SQL statements, though output may vary:

ANALYZE TABLE
EXPLAIN and EXPLAIN REFERENCED
OPTIMIZE TABLE
- Xpand supports the syntax for OPTIMIZE TABLE, but does not perform any operation. Xpand uses background processes to automatically optimize storage.
REPAIR TABLE
SHOW BINARY LOGS
SHOW CHARACTER SET (with no WHERE clause)
SHOW COLLATION
SHOW COLUMNS
SHOW CREATE [DATABASE | TABLE | FUNCTION | TRIGGER | SEQUENCE | | USER | VIEW]
SHOW DATABASES
SHOW ENGINES
- For compatibility, Xpand lists InnoDB as part of the output of SHOW ENGINES, but the Xpand engine will always be applied.
- Not all engines are listed as output of SHOW. See ENGINES for more information.
SHOW GRANTS
SHOW INDEX
SHOW MASTER STATUS
SHOW OPEN TABLES
SHOW PROCESSLIST
SHOW SLAVE HOSTS
SHOW STATUS
SHOW TABLES
SHOW TRIGGER
SHOW WARNINGS
- The syntax for SHOW WARNINGS is supported, but no warnings are ever displayed.
SHOW VARIABLES

Xpand does not support: