Hi! Could we please enable some services and cookies to improve your experience and our website?

SQLize | PHPize | SQLtest

Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code

A A A
Login    Share code      Blog   FAQ
Copy Format Clear
sql -- Create the departments table CREATE TABLE departments ( DepartmentID SERIAL PRIMARY KEY, DepartmentName VARCHAR(50) NOT NULL ); -- Create the employees table CREATE TABLE employees ( EmployeeID SERIAL PRIMARY KEY, FirstName VARCHAR(50) NOT NULL, LastName VARCHAR(50) NOT NULL, DepartmentID INTEGER NOT NULL, FOREIGN KEY (DepartmentID) REFERENCES departments(DepartmentID) );

Stuck with a problem? Got Error? Ask AI support!

Copy Clear