云数据库 GaussDB-ALTER SEQUENCE:示例

时间：2025-02-12 15:07:58

云数据库 GaussDB

示例

  
       --创建一个名为serial的递增序列，从101开始。gaussdb=# CREATE SEQUENCE serial START 101;--创建一个表,定义默认值。gaussdb=# CREATE TABLE t1(c1 bigint default nextval('serial'));--将序列serial的归属列变为t1.c1。gaussdb=# ALTER SEQUENCE serial OWNED BY t1.c1;--删除序列和表。gaussdb=# DROP SEQUENCE serial CASCADE;gaussdb=# DROP TABLE t1;--创建一个序列seq_test。gaussdb=# CREATE SEQUENCE seq_test;--查询序列信息。gaussdb=# \ds               List of relations Schema |   Name   |   Type   | Owner | Storage --------+----------+----------+-------+--------- public | seq_test | sequence | omm   | (1 row)--创建用户u_test并修改序列所有者。gaussdb=# CREATE USER u_test PASSWORD '********';gaussdb=# ALTER SEQUENCE seq_test OWNER TO u_test;gaussdb=# \ds                List of relations Schema |   Name   |   Type   | Owner  | Storage --------+----------+----------+--------+--------- public | seq_test | sequence | u_test | (1 row)--删除用户和序列。gaussdb=# DROP SEQUENCE seq_test;gaussdb=# DROP USER u_test;