Database Management Syntax
Supported Database Management Syntax
- SHOW COLUMNS
- SHOW CREATE TABLE
- SHOW TABLE STATUS
- SHOW TABLES
- SHOW DATABASESNote
If the required database is not found, check fine-grained permissions of your account.
- SHOW INDEX FROM
- SHOW VARIABLES
Supported Database Tool Commands
- DESC
- USE
- EXPLAINNote
Unlike EXPLAIN in MySQL, the output of DDM EXPLAIN describes the nodes that the current SQL statement is routed to.
Unsupported Database Management Syntax
- Executing SET to modify global variables
- SHOW TRIGGERS statements are not supported.
- CHECK TABLE does not support sharding tables by hash or sharding key.
- SHOW WARNINGS and SHOW ERRORS do not support the combination of LIMIT and COUNT. The SHOW statements are randomly sent to a database shard. If database shards are on different RDS for MySQL instances, the returned variables or table information may be different.
Parent topic: SQL Syntax
- Supported Database Management Syntax
- Supported Database Tool Commands
- Unsupported Database Management Syntax