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