Skip to main content

SHOW-PARTITION-ID

Description​

This statement is used to find the corresponding database name, table name, partition name according to the partition id (only for administrators)

Syntax​

SHOW PARTITION [partition_id]

Example​

  1. Find the corresponding database name, table name, partition name according to the partition id

    SHOW PARTITION 10002;

Keywords​

SHOW, PARTITION, ID