Skip to main content

SHOW-PARTITION-ID

SHOW-PARTITION-ID​

Name​

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)

grammar:

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

Best Practice​