Try it Yourself: SQL Constraints – Hyring Learn

LessonBack to lesson

SQL Constraints

Language: SQL

CREATE TABLE Users (
    UserID     INT NOT NULL PRIMARY KEY,
    Email      VARCHAR(255) UNIQUE,
    Username   VARCHAR(50),
    CONSTRAINT uq_username UNIQUE (Username)
);

CREATE TABLE Users (
    UserID     INT NOT NULL PRIMARY KEY,
    Email      VARCHAR(255) UNIQUE,
    Username   VARCHAR(50),
    CONSTRAINT uq_username UNIQUE (Username)
);

Output

Click Run to execute this code.