数据仓库服务 GAUSSDB(DWS)-ALTER SEQUENCE:语法格式

时间:2024-10-21 16:50:36

语法格式

修改序列最大值或归属列

1
2
3
4
ALTER SEQUENCE [ IF EXISTS ] name 
    [ MAXVALUE maxvalue | NO MAXVALUE | NOMAXVALUE ]
    [ CACHE cachevalue ]
    [ OWNED BY { table_name.column_name | NONE } ] ;

修改序列的拥有者

1
ALTER SEQUENCE [ IF EXISTS ] name OWNER TO new_owner;
support.huaweicloud.com/sqlreference-830-dws/dws_06_0137.html