📣

TiDB Cloud Serverless 现已更名为
Starter
!此页面由 AI 自动翻译,英文原文请见
此处。

SHOW CREATE SEQUENCE

SHOW CREATE SEQUENCE 显示序列的详细信息,类似于 SHOW CREATE TABLE

概述

ShowCreateSequenceStmt
SHOWCREATESEQUENCESchemaName.TableName

示例

CREATE SEQUENCE seq;
Query OK, 0 rows affected (0.03 sec)
SHOW CREATE SEQUENCE seq;
+-------+----------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+----------------------------------------------------------------------------------------------------------------------------+ | seq | CREATE SEQUENCE `seq` start with 1 minvalue 1 maxvalue 9223372036854775806 increment by 1 cache 1000 nocycle ENGINE=InnoDB | +-------+----------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)

MySQL 兼容性

该语句是 TiDB 的扩展功能。其实现借鉴了 MariaDB 中的序列机制。

相关链接

文档内容是否有帮助?