Column (database)

In a <a href="/facts/Relational_database/pEKGmJLy">relational database</a>, a column is a set of <a href="/facts/Data/AUBFN97o">data</a> values of a particular <a href="/facts/Datatype/fcx5hgVL">type</a>, one value for each <a href="/facts/Row_(database)/PIpv7c9e">row</a> of a <a href="/facts/Table_(database)/5INvK1Vd">table</a>. A column may contain text values, numbers, or even pointers to files in the operating system. Columns typically contain <a href="/facts/Primitive_data_type/0c898228">simple types</a>, though some relational database systems allow columns to contain more complex data types, such as whole documents, images, or even video clips.[better source needed] A column can also be called an attribute.
Each row would provide a data value for each column and would then be understood as a single structured data value. For example, a database that represents company contact information might have the following columns: ID, Company Name, Address Line 1, Address Line 2, City, and Postal Code. More formally, a row is a tuple containing a specific value for each column, for example: (1234, 'Big Company Inc.', '123 East Example Street', '456 West Example Drive', 'Big City', 98765).

Column (database) open-in-new

Column (database)