SHOW DYNAMIC PARTITION TABLES

description

1. This statement is used to display all dynamically partitioned table states under the current db
2. Grammar:
3. SHOW DYNAMIC PARTITION TABLES [FROM db_name];

example

1. 1. Displays all dynamically partitioned table states for the database
2. SHOW DYNAMIC PARTITION TABLES FROM database;

keyword

1. SHOW,DYNAMIC,PARTITION,TABLES