vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/ddm/umn/ddm_12_0100.html
Ru, Li Yi 4b09a03a51 ddm_umn 
Reviewed-by: Wagner, Fabian <fabian.wagner@t-systems.com>
Co-authored-by: Ru, Li Yi <liyiru7@huawei.com>
Co-committed-by: Ru, Li Yi <liyiru7@huawei.com>
2024-04-11 11:39:26 +00:00

3.5 KiB
Raw Permalink Blame History

Supported System Schema Queries

Table 1 Supported system schema queries

DML Syntax

Restriction

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