序列值-SYS_SEQUENCES

📄字数 820

👁️阅读量 加载中...

功能描述

SYS_SEQUENCES系统表用于存储、管理系统库和用户库中所有创建的序列值信息。

字段说明

序号	字段名	类型	说明	V11	V12
0	DB_ID	INTEGER	库ID	√	√
1	SCHEMA_ID	INTEGER	模式ID	√	√
2	USER_ID	INTEGER	属主ID	√	√
3	SEQ_ID	INTEGER	序列值ID	√	√
4	SEQ_NAME	VARCHAR	序列值产生器的名称	√	√
5	IS_CYCLE	BOOLEAN	是否循环	√	√
6	IS_ORDER	BOOLEAN	是否有序	√	√
7	CACHE_VAL	INTEGER	是否缓存一些序列值	√	√
8	CURR_VAL	BIGINT	当前值	√	√
9	MAX_VAL	BIGINT	最大值	√	√
10	MIN_VAL	BIGINT	最小值	√	√
11	STEP_VAL	BIGINT	增长步长	√	√
12	CREATE_TIME	DATETIME	创建时间	√	√
13	IS_SYS	BOOLEAN	是否系统内建	√	√
14	VALID	BOOLEAN	是否有效	√	√
15	COMMENTS	VARCHAR	注释信息	√	√
16	RESERVED1	VARCHAR	保留字段	√	√
17	RESERVED2	VARCHAR	保留字段	√	√

应用举例

• 查询系统序列相关信息

SQL> CREATE SEQUENCE seq_test MINVALUE 10 MAXVALUE 1000 START WITH 20 INCREMENT BY 10 CACHE 5 COMMENT 'test sequence to be modified';

SQL> SELECT * FROM SYS_SEQUENCES WHERE seq_name='SEQ_TEST';
+-------+-----------+---------+---------+----------+----------+----------+-----------+----------+---------+---------+----------+--------------------------+--------+--------+------------------------------+-----------+-----------+
| DB_ID | SCHEMA_ID | USER_ID | SEQ_ID  | SEQ_NAME | IS_CYCLE | IS_ORDER | CACHE_VAL | CURR_VAL | MAX_VAL | MIN_VAL | STEP_VAL |       CREATE_TIME        | IS_SYS | VALID  |           COMMENTS           | RESERVED1 | RESERVED2 |
+-------+-----------+---------+---------+----------+----------+----------+-----------+----------+---------+---------+----------+--------------------------+--------+--------+------------------------------+-----------+-----------+
| 1     | 1         | 1       | 1048591 | SEQ_TEST | F        | <NULL>   | 5         | 20       | 1000    | 10      | 10       | 2025-07-03 17:15:08.614  | F      | <NULL> | test sequence to be modified | <NULL>    | <NULL>    |
+-------+-----------+---------+---------+----------+----------+----------+-----------+----------+---------+---------+----------+--------------------------+--------+--------+------------------------------+-----------+-----------+

相关系统表

• SYS_DATABASES
• SYS_SCHEMAS