Table

noun

say it: “TAY-bul” /ˈteɪbəl/

A set of data in a database arranged in rows and columns, one row per record.

What is Table in a relational database?

Table — The common SQL representation of a relation, arranged in rows and columns.

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

In a sentence

  • “The Products table has one row for each product.”

Level: Novice · More Database terms at this level

Updated