Help Center/ Distributed Database Middleware/ User Guide (Kuala Lumpur Region)/ SQL Syntax/ Supported SQL Statements/ CHECK TABLE/ Checking DDL Consistency of Table Shards in One Logical Table
Updated on 2022-08-17 GMT+08:00
View PDF
Share

Checking DDL Consistency of Table Shards in One Logical Table

Purpose: to check DDL consistency of table shards in a specific logical table

Command format:

check table <table_name>

Command Output:

If the returned result set is empty, DDL results of table shards in this logical table are consistent.

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

Output Details:

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

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