CREATE TABLE

Published May 7, 2021Updated Jun 25, 2022
Contribute to Docs

The CREATE TABLE command creates a new table within a database.

Syntax

CREATE TABLE table_name (
  column_name column_definition,
  column_name column_definition,
  ...
);

Example

CREATE TABLE students (
student_id int,
last_name varchar(255),
first_name varchar(255),
local_address varchar(255),
home_of_record varchar(255),
major varchar(255),
overall_gpa decimal(3,2)
);

All contributors

Looking to contribute?

Learn SQL on Codecademy