SQL CREATE TABLE: Examples

CREATE TABLE courses (
    course_id INT PRIMARY KEY AUTOINCREMENT,
    course_name VARCHAR(50) NOT NULL
);

CREATE TABLE training (
    employee_id INT,
    course_id INT,
    taken_date DATE,
    PRIMARY KEY (employee_id , course_id)
);

SELECT * FROM countries;

SELECT * FROM departments;

SELECT * FROM dependents;

SELECT * FROM employees;

SELECT * FROM jobs;

SELECT * FROM locations;

SELECT * FROM regions;

Execute

Clear Beautify Minify

Reload