Help Center/ Distributed Database Middleware/ User Guide/ SQL Syntax/ Database Management Syntax
Updated on 2024-07-30 GMT+08:00
View PDF
Share

Database Management Syntax

Supported Database Management Syntax

  • SHOW COLUMNS
  • SHOW CREATE TABLE
  • SHOW TABLE STATUS
  • SHOW TABLES
  • SHOW DATABASES

    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
  • EXPLAIN

    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