Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Data Types in SQL

Introduction
Modifying columns
Modifying identities
Modifying sequences
11. Changing sequence increments
Summary

Instruction

Great! You can also change the increment part of a sequence. Let's say we have the following sequence:

CREATE SEQUENCE standard_seq START WITH 1 INCREMENT BY 1;

Now, if we want to change the increment to 10, we can use:

ALTER SEQUENCE standard_seq INCREMENT BY 10;

Exercise

The agency also wants the artist_numbers sequence to increment by 1, not 2. Your task is to change that.