LucidDbAlterColumn

Syntax

ALTER TABLE qualified-table-name
    ALTER COLUMN unqualified-column-name { alter-identity-column-spec ... }
 
alter-identity-column-spec ::= 
RESTART WITH numeric-literal
| SET basic-sequence-generator-option

basic-sequence-generator-option ::=
INCREMENT BY numeric-literal
| MAXVALUE numeric-literal
| NO MAXVALUE 
| MINVALUE numeric-literal
| NO MINVALUE 
| CYCLE 
| NO CYCLE

Example

ALTER TABLE warehouse.employee_dimension ALTER COLUMN emp_key RESTART WITH 10 SET MAXVALUE 10000 SET CYCLE;