New in v2.0: SHOW CREATE SEQUENCE 语句 用于显示创建特定序列的 CREATE SEQUENCE 语句。

所需权限

用户需拥有目标序列的任一 权限

概要

图片

参数

Parameter Description
sequence_name 序列名

返回

Field Description
Sequence 序列名
CreateSequence 创建一个特定序列CREATE SEQUENCE 语句。

例子

> CREATE SEQUENCE desc_customer_list START -1 INCREMENT -2;
> SHOW CREATE SEQUENCE desc_customer_list;
+--------------------+----------------------------------------------------------------------------------------------------+
|      Sequence      |                                           CreateSequence                                           |
+--------------------+----------------------------------------------------------------------------------------------------+
| desc_customer_list | CREATE SEQUENCE desc_customer_list MINVALUE -9223372036854775808 MAXVALUE -1 INCREMENT -2 START -1 |
+--------------------+----------------------------------------------------------------------------------------------------+

See Also