Try it Yourself: SQL Constraints – Hyring Learn

LessonBack to lesson

SQL Constraints

Language: SQL

CREATE TABLE Accounts (
    AccountID INT NOT NULL PRIMARY KEY,
    Balance   DECIMAL(12, 2) CHECK (Balance >= 0),
    Country   VARCHAR(2),
    Age       INT,
    CONSTRAINT chk_age CHECK (Age >= 18)
);

CREATE TABLE Accounts (
    AccountID INT NOT NULL PRIMARY KEY,
    Balance   DECIMAL(12, 2) CHECK (Balance >= 0),
    Country   VARCHAR(2),
    Age       INT,
    CONSTRAINT chk_age CHECK (Age >= 18)
);

Output

Click Run to execute this code.