Home  >  Blog  >   Snowflake

How to Alter a Sequence in Snowflake

Altering the sequence is a process of modifying the sequence of numbers in a series. For altering the sequence, we will use “Alter Sequence”  and “Increment” commands. This blog illustrates those commands with examples.

Rating: 4.6
  1. Share:
Snowflake Articles

In Snowflake, we can create a number sequence through the “create sequence”  command.  After creating the sequence, we can alter the sequence. In this blog, we will discuss altering the sequence.

By default, auto-incrementing columns start at 1. But, sometimes, we want them to begin at a different number or/and increment by a different amount. These numbers are called “sequences.” The syntax for creating Sequences:

Alter Sequence in Snowflake

create sequence sequence_name

start = number1;
increment = number1;
Looking forward to a career in a cloud data warehousing domain? Check out the "Snowflake Training" and get certified today


create sequence odd_numbers

start = 1;
increment = 2;

create sequence positive_numbers

start = 0;
increment = 1;

 MindMajix YouTube Channel

For altering the sequences, we should use the “ALTER SEQUENCE” command:

  1. Changing the Number of the sequence:
alter sequence odd numbers
set increment  = 11;

      2. Setting a Comment for the Sequence

alter sequence odd_numbers
set comment = ‘odd dozens’

      3. Renaming the Sequence

alter sequence odd_numbers rename to odd_numbers_dozens;


In Snowflake, we will create the sequence to print the numbers in order. When we want to change the order, we will alter the sequence. I hope this article gives you sufficient information about Altering the Sequence in Snowflake.

Snowflake Related Articles

▶  Snowflake vs Redshift
▶  Snowflake vs BigQuery
▶  Snowflake vs Databricks
▶  Snowflake vs Azure
▶  Snowflake vs Hadoop
▶  Snowflake Time Travel

Join our newsletter

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
Snowflake TrainingMar 02 to Mar 17View Details
Snowflake TrainingMar 05 to Mar 20View Details
Snowflake TrainingMar 09 to Mar 24View Details
Snowflake TrainingMar 12 to Mar 27View Details
Last updated: 04 Apr 2023
About Author

Viswanath is a passionate content writer of Mindmajix. He has expertise in Trending Domains like Data Science, Artificial Intelligence, Machine Learning, Blockchain, etc. His articles help the learners to get insights about the Domain. You can reach him on Linkedin

read more