---
title: "查看序列 - OceanBase 数据库 V4.3.4 | OceanBase 文档中心"
description: "查看序列 创建序列后，可以通过 SHOW SEQUENCES 语句或视图来查看序列。 通过 SHOW SEQUENCES 语句查看序列 SHOW SEQUENCES 语句可以查看当前租户创建的所有序列。 语句如下： obclient> SHOW SEQUENCES [LIKE expression | LIKE ex…"
---
切换语言

- 中文站 - 简体中文
- International - English
- 日本站 - 日本語

文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 4.3.4

# 查看序列

更新时间：2024-12-15 23:00:00

[编辑](https://github.com/oceanbase/oceanbase-doc/edit/V4.3.4/zh-CN/700.reference/300.database-object-management/100.manage-object-of-mysql-mode/700.manage-sequence-of-mysql-mode/200.view-a-sequence-of-mysql-mode.md)  

创建序列后，可以通过 `SHOW SEQUENCES` 语句或视图来查看序列。

## 通过 SHOW SEQUENCES 语句查看序列

`SHOW SEQUENCES` 语句可以查看当前租户创建的所有序列。

语句如下：

```sql
obclient> SHOW SEQUENCES
              [LIKE expression
               | LIKE expression IN database_name
               | IN database_name
               | WHERE sequence_name='sequence_name'
              ];

```

相关参数说明如下：

- `LIKE expression`：用于指定待查询的序列名的相关信息。
 - `IN database_name`：用于指定待查询的序列所属的数据库。
 - `WHERE sequence_name='sequence_name'`：用于指定待查询的序列名。

示例如下：

- 查看当前租户创建的所有序列。

  ```sql
  obclient> SHOW SEQUENCES;
  +-------------------+
  | Sequences_in_test |
  +-------------------+
  | seq1              |
  | meq2              |
  +-------------------+
  2 rows in set

  ```
 - 查看序列名中含 `s` 的所有序列。

  ```sql
  obclient> SHOW SEQUENCES LIKE '%s%';
  +-------------------------+
  | Sequences_in_test (%s%) |
  +-------------------------+
  | seq1                    |
  +-------------------------+
  1 rows in set

  ```
 - 查看数据库 `test` 中的所有序列。

  ```sql
  obclient> SHOW SEQUENCES IN test;
  +-------------------+
  | Sequences_in_test |
  +-------------------+
  | seq1              |
  | meq2              |
  +-------------------+
  2 rows in set

  ```
 - 查看当前租户内名为 `seq1` 的序列。

  ```sql
  obclient> SHOW SEQUENCES WHERE sequence_name='seq1';
  +-------------------+
  | Sequences_in_test |
  +-------------------+
  | seq1              |
  +-------------------+
  1 row in set

  ```

## 通过视图查看序列

OceanBase 数据库的 MySQL 租户可以通过查询 `oceanbase.DBA_OB_SEQUENCE_OBJECTS` 视图来查看当前租户内的所有序列信息，包括序列 ID、序列名、序列所属的数据库、序列取值的起始值、序列每次取值的步长、序列的循环属性以及序列可取的最大值和最小值等信息。

查询示例如下：

```sql
obclient> SELECT * FROM oceanbase.DBA_OB_SEQUENCE_OBJECTS;
+-------------+------------------+-------------+---------------+-----------+-----------+--------------+------------+------------+------------+------------+---------------------+
| SEQUENCE_ID | SCHEMA_VERSION   | DATABASE_ID | SEQUENCE_NAME | MIN_VALUE | MAX_VALUE | INCREMENT_BY | START_WITH | CACHE_SIZE | ORDER_FLAG | CYCLE_FLAG | IS_SYSTEM_GENERATED |
+-------------+------------------+-------------+---------------+-----------+-----------+--------------+------------+------------+------------+------------+---------------------+
|      500003 | 1675748057234736 |      500002 | seq1          |         1 |        10 |            2 |          1 |         30 |          0 |          0 |                   0 |
+-------------+------------------+-------------+---------------+-----------+-----------+--------------+------------+------------+------------+------------+---------------------+
1 row in set

```

有关 `oceanbase.DBA_OB_SEQUENCE_OBJECTS` 视图字段的更多说明，参见 [oceanbase.DBA_OB_SEQUENCE_OBJECTS](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000001575920)。

## 相关文档

更多序列相关的操作，参见以下文档：

- [创建序列](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000001576004)
 - [引用序列](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000001576003)
 - [修改序列](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000001576007)
 - [删除序列](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000001576005)

 上一篇 下一篇 ![有帮助](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) 咨询热线