--- title: "查看动态分区表 - OceanBase 数据库 V4.5.0 | OceanBase 文档中心" description: 查看动态分区表 动态分区表创建成功后，您可以通过 SHOW CREATE TABLE 语句查看表的定义和视图查看数据库中的动态分区表信息。 查看表的定义 表创建成功后，您可以使用 SHOW CREATE TABLE table_name; 语句查看表的定义。 更多有关 SHOW 语句的介绍信息，参见 SHOW 。 示… --- 切换语言 - 中文站 - 简体中文 - International - English - 日本站 - 日本語 文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 4.5.0 # 查看动态分区表 更新时间：2026-03-26 10:51:33 [编辑](https://github.com/oceanbase/oceanbase-doc/edit/V4.5.0/zh-CN/700.reference/300.database-object-management/100.manage-object-of-mysql-mode/300.manage-partitions-of-mysql-mode/260.dynamic-partition-of-mysql-mode/300.view-dynamic-partition-table-of-mysql-mode.md) 动态分区表创建成功后，您可以通过 `SHOW CREATE TABLE` 语句查看表的定义和视图查看数据库中的动态分区表信息。 ## 查看表的定义 表创建成功后，您可以使用 `SHOW CREATE TABLE table_name;` 语句查看表的定义。 更多有关 `SHOW` 语句的介绍信息，参见 [SHOW](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000004479581)。 **示例如下：** 查看表 `test_tbl1` 的定义。 ```sql SHOW CREATE TABLE test_tbl1; ``` 查询结果如下： ```shell +-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | test_tbl1 | CREATE TABLE `test_tbl1` ( `col1` int(11) DEFAULT NULL, `col2` datetime DEFAULT NULL ) ORGANIZATION INDEX DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = 'zstd_1.3.8' REPLICA_NUM = 1 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE ENABLE_MACRO_BLOCK_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0 DYNAMIC_PARTITION_POLICY = (ENABLE = TRUE, TIME_UNIT = 'HOUR', PRECREATE_TIME = '3HOUR', EXPIRE_TIME = '1DAY', TIME_ZONE = '+8:00', BIGINT_PRECISION = 'NONE') partition by range columns(col2) (partition `P0` values less than ('2025-04-15 13:30:00')) | +-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set ``` ## 使用视图查看动态分区表信息 | 视图名 | 功能描述 | | --- | --- | | [oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000004478232) | 展示本租户的动态分区表信息。 | | [oceanbase.V$OB_DYNAMIC_PARTITION_TABLES](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000004478052) | 展示当前租户的动态分区表信息。该视图从内存中读取动态分区表相关属性，读取性能较好。 | **示例如下：** ```sql SELECT * FROM oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES WHERE TABLE_NAME = 'test_tbl1'; ``` 返回结果如下： ```shell +---------------+------------+----------+-----------------------+--------+-----------+----------------+-------------+-----------+------------------+ | DATABASE_NAME | TABLE_NAME | TABLE_ID | MAX_HIGH_BOUND_VAL | ENABLE | TIME_UNIT | PRECREATE_TIME | EXPIRE_TIME | TIME_ZONE | BIGINT_PRECISION | +---------------+------------+----------+-----------------------+--------+-----------+----------------+-------------+-----------+------------------+ | db_test | test_tbl1 | 511391 | '2025-04-15 13:30:00' | TRUE | HOUR | 3HOUR | 1DAY | +8:00 | NONE | +---------------+------------+----------+-----------------------+--------+-----------+----------------+-------------+-----------+------------------+ 1 row in set ``` ## 相关文档 - [动态分区概述](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000004479328) - [创建动态分区表](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000004479327) - [修改动态分区表](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000004479326) - [动态分区管理任务](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000004479325) 上一篇 下一篇 ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线