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)

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

Best Practice