Help Center/ Distributed Database Middleware/ User Guide/ SQL Syntax/ Supported SQL Statements/ CHECK TABLE/ Checking DDL Consistency of All Physical Tables Corresponding to One Logical Table
Updated on 2024-07-30 GMT+08:00
View PDF
Share

Checking DDL Consistency of All Physical Tables Corresponding to One Logical Table

Purpose: To check DDL consistency of all physical tables corresponding to a specific logical table

Command Format:

check table <table_name>

Command Output:

If the returned result set is empty, DDL results of all physical tables corresponding to this logical table are consistent.

If the returned result set is not empty, there are physical tables with inconsistent DDL results.

Output Details:

Each row displays details of a physical table with inconsistent DDL results.

  • DATABASE_NAME: indicates the database shard containing the physical table.
  • TABLE_NAME: indicates the name of the physical table.
  • TABLE_TYPE: indicates the type of the logical table that the physical table belongs to.
  • EXTRA_COLUMNS: indicates extra columns in the physical table.
  • MISSING_COLUMNS: indicates missing columns in the physical table.
  • DIFFERENT_COLUMNS: indicates name and type columns whose attributes are inconsistent in the physical table.
  • KEY_DIFF: indicates inconsistent indexes in the physical table.
  • ENGINE_DIFF: indicates inconsistent engines in the physical table.
  • CHARSET_DIFF: indicates inconsistent character sets in the physical table.
  • COLLATE_DIFF: indicates inconsistent collations in the physical table.
  • EXTRA_PARTITIONS: indicates extra partitions in the physical table. This field is only available to partitioned tables.
  • MISSING_PARTITIONS: indicates missing partitions in the physical table. This field is only available to partitioned tables.
  • DIFFERENT_PARTITIONS: indicates partitions with inconsistent attributes in the physical table. This field is only available to partitioned tables.
  • EXTRA_INFO: indicates other information such as missing physical tables.
Parent topic: CHECK TABLE