Database Management Syntax¶
Supported Database Management Syntax¶
SHOW Syntax
SHOW COLUMNS Syntax
SHOW CREATE TABLE Syntax
SHOW TABLE STATUS Syntax
SHOW TABLES Syntax
SHOW DATABASES
If the required database is not found, check fine-grained permissions of your account.
SHOW INDEX FROM
SHOW VARIABLES Syntax
Supported Database Tool Commands¶
DESC Syntax
USE Syntax
EXPLAIN Syntax
Unlike EXPLAIN in MySQL, the output of DDM EXPLAIN describes the nodes that the current SQL statement is routed to.
Unsupported Database Management Syntax¶
Item | Restriction |
|---|---|
Database management statements |
The following 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.
|