Help Center/ Distributed Database Middleware/ User Guide (ME-Abu Dhabi Region)/ SQL Syntax/ Supported SQL Statements/ CHECK TABLE/ Checking DDL Consistency of Table Shards in All Logical Tables
Updated on 2022-12-08 GMT+08:00
View PDF
Share

Checking DDL Consistency of Table Shards in All Logical Tables

Purpose: To view DDL consistency of all logical tables in one schema

Command Format:

 check table

Command Output:

The following output is returned if DDL check results of all logical tables are consistent.

The following output is returned if there are logical tables with inconsistent DDL check results.

Output Details:

Each row indicates the check result of a logical table.

  • DATABASE_NAME: indicates the schema name.
  • TABLE_NAME: indicates the logical table name.
  • TABLE_TYPE: indicates the logical table type.
    • SINGLE: indicates that the logical table is unsharded.
    • BROADCAST: indicates that the table is a broadcast table.
    • SHARDING: indicates that the table is sharded.
  • DDL_CONSISTENCY: indicates whether DDL results of all table shards corresponding to the logical table are consistent.
  • TOTAL_COUNT: indicates the number of table shards in the logical table.
  • INCONSISTENT_COUNT: indicates the number of table shards with inconsistent DDL results.
  • DETAILS: indicates names of the table shards with inconsistent DDL check results.
Parent topic: CHECK TABLE