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

时间:2024-10-16 16:27:24

语法格式

修改序列最大值或归属列

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

修改序列的拥有者

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