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