OneCompiler

Creating table with constraints

97

CREATE TABLE Employees(
EmployeeID INT PRIMARY KEY,
FirstName VARCHAR(50) NOT NULL,
LastName VARCHAR(50) NOT NULL,
Email VARCHAR(100) UNIQUE,
Age INT CHECK(Age >= 18)
);

INSERT INTO Employees(EmployeeID, FirstName, LastName, Email, Age) VALUES ( 1, 'Alice', 'Johnson', '[email protected]', 50);

UPDATE Employees SET Email='[email protected]' WHERE EmployeeID=1;

DELETE FROM Employees WHERE EmployeeID=1;