Help Center> Distributed Database Middleware> User Guide> SQL Syntax> Supported SQL Statements> CHECK TABLE> Checking DDL Consistency of Physical Tables in All Logical Tables
Updated on 2023-10-09 GMT+08:00

Checking DDL Consistency of Physical Tables in All Logical Tables

Purpose: To check 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 contains 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 physical tables corresponding to the logical table are consistent.
  • TOTAL_COUNT: indicates the number of physical tables in the logical table.
  • INCONSISTENT_COUNT: indicates the number of physical tables with inconsistent DDL results.
  • DETAILS: indicates names of the physical tables with inconsistent DDL check results.