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