SHOW DYNAMIC PARTITION TABLES

Description

This statement is used to display the status of all dynamic partition tables under the current db

grammar:

SHOW DYNAMIC PARTITION TABLES [FROM db_name];

Example

1. Display all dynamic partition table status of database database

   SHOW DYNAMIC PARTITION TABLES FROM database;

Keywords

SHOW, DYNAMIC, PARTITION

Best Practice