Try it Yourself: SQL Constraints – Hyring Learn

LessonBack to lesson

SQL Constraints

Language: SQL

CREATE TABLE Employees (
    EmployeeID   INT NOT NULL,
    Email        VARCHAR(255) UNIQUE,
    FullName     VARCHAR(120) NOT NULL,
    Salary       DECIMAL(10, 2) CHECK (Salary >= 0),
    Department   VARCHAR(60) DEFAULT 'Unassigned',
    PRIMARY KEY (EmployeeID)
);

CREATE TABLE Employees (
    EmployeeID   INT NOT NULL,
    Email        VARCHAR(255) UNIQUE,
    FullName     VARCHAR(120) NOT NULL,
    Salary       DECIMAL(10, 2) CHECK (Salary >= 0),
    Department   VARCHAR(60) DEFAULT 'Unassigned',
    PRIMARY KEY (EmployeeID)
);

Output

Click Run to execute this code.