Help Center/ Distributed Database Middleware/ User Guide/ SQL Syntax/ DML/ Supported System Schema Queries
Updated on 2024-04-01 GMT+08:00
View PDF
Share

Supported System Schema Queries

Table 1 Supported System Schema Queries

DML Syntax

Constraint

System schema queries

The following system schema queries are supported:

Version query: SELECT version()

  • information_schema.SCHEMA_PRIVILEGES
  • information_schema.TABLE_PRIVILEGES
  • information_schema.USER_PRIVILEGES
  • information_schema.SCHEMATA
  • information_schema.tables
  • information_schema.columns

Index query: SHOW KEYS FROM <table> FROM <database>

NOTE:
  • Supported operators include =, IN, and LIKE. These operators can be associated using AND.
  • Complex queries, such as subquery, JOIN, sorting, aggregate query, and LIMIT, are not supported.
  • information_schema.tables and information_schema.columns support operators < and >.

Parent topic: DML