Column

noun

say it: “KOL-um” /ˈkɒləm/

One named field in a database table, with a data type, holding one kind of value for every row.

What is Column in a relational database?

Column — A named part of a table that holds values from a defined data type or domain.

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

In a sentence

  • “The UnitPrice column holds each product's price as money.”

Level: Novice · More Database terms at this level

Updated