# 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.

```sql
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](https://www.ask-codey.com/glossary?category=sql&level=2)

Updated: November 9, 2026

Source: https://www.ask-codey.com/glossary/create-table
