sql,SHOW CREATE TABLE table_name;,
`,,或者使用
INFORMATION_SCHEMA 数据库中的
PARTITIONS 表来获取更详细的分区信息:,,
`sql,SELECT PARTITION_NAME, SUBPARTITION_NAME, PARTITION_ORDINAL_POSITION, SUBPARTITION_ORDINAL_POSITION, PARTITION_METHOD, SUBPARTITION_METHOD,FROM INFORMATION_SCHEMA.PARTITIONS,WHERE TABLE_SCHEMA = 'your_database_name' AND TABLE_NAME = 'your_table_name';,
``