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
Identity columns
Sequences
Summary

Instruction

Perfect. The code worked like a charm! However, you should also remember that using GENERATED ALWAYS AS IDENTITY doesn't allow you to provide any specific values on your own. Just as the syntax suggests, the values are GENERATED ALWAYS, with no exception. Let's check that.

Exercise

Now, try to add a row with your own value for the id column. This statement will fail. When you use GENERATED ALWAYS AS IDENTITY, you can never provide your own values for the given column.

You can run the template or create your own query. When you're done with the exercise, click I'm done. Next exercise.

Stuck? Here's a hint!

Simply run a template query.