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

SQL Constraints

Introduction
Defining columns with UNIQUE
Adding and removing UNIQUE constraints
Summary

Instruction

As you have seen, the values in the name column are indeed unique. After all, no two games should share the same name, right?

Exercise

Let's add another board game to our board_game table. It's called Carcassonne, the genre is medieval, the minimum number of players is 2, the minimum age is 10, and the price is listed at 32.99. Don't worry about the id column – it's defined as GENERATED ALWAYS AS IDENTITY and IDENTITY will take care of the numbering.

Stuck? Here's a hint!

Syntax reminder:

INSERT INTO board_game (...)
VALUES (...);