SELECT   partition_name part,    partition_expression expr,    partition_description descr,    table_rows  FROM   INFORMATION_SCHEMA.partitions  WHERE   TABLE_SCHEMA = schema()    AND TABLE_NAME=‘table‘;