CREATE TABLE

noun

say it: “kree-AYT TAY-bul” /kriˈeɪt ˈteɪbəl/

The SQL statement that makes a new table, with its columns, types and rules.

What is CREATE TABLE in a relational database?

CREATE TABLE — A statement that defines a new table, its columns, and its constraints.

CREATE TABLE customer (
    customer_id INTEGER PRIMARY KEY,
    email CHARACTER VARYING(255) NOT NULL,
    status CHARACTER VARYING(20) DEFAULT 'active'
);

In a sentence

  • “I used CREATE TABLE to make Members with an id, a name and a city.”

Level: Apprentice · More SQL terms at this level

Updated