MSCEWI3044

An option was removed from the options.

Severity

Low

Description

An option was removed from a CREATE SEQUENCE query because is not supported in Snowflake.

Example Code:

Input Code:

CREATE SEQUENCE SequenceSample
START WITH     1000
INCREMENT BY   1
NOCACHE
NOCYCLE
NOPARTITION;

Output Code:

/*** MSC-WARNING - MSCEWI3044 - NOCACHE REMOVED FROM THE OPTIONS. ***/
/*** MSC-WARNING - MSCEWI3044 - NOCYCLE REMOVED FROM THE OPTIONS. ***/
/*** MSC-WARNING - MSCEWI3044 - NOPARTITION REMOVED FROM THE OPTIONS. ***/
CREATE SEQUENCE PUBLIC.SequenceSample
START WITH     1000
INCREMENT BY   1;

Recommendations