Skip to main content
Version: 4.x

SHOW PARTITION ID

Description​

This statement is used to find the corresponding database name, table name, and partition name based on the partition ID.

Syntax​

SHOW PARTITION <partition_id>

Required Parameters​

1. <partition_id>

partition id

Access Control Requirements​

The user who executes this SQL must have at least the following permissions:

PrivilegeObjectNotes
ADMIN_PRIV

Examples​

  1. To find the corresponding database name, table name, and partition name based on the partition ID.

    SHOW PARTITION 10002;