Row (database)

In a relational database, a row or "record" or "tuple", represents a single, implicitly structured data item in a table.

Uses your system voice; voice and rate in settings.

≈ 3 min read

Cite, export and learn8 citation formats · 8 exports · lesson and quiz

Names in other languages

No names in other languages are held for this entry yet.

Article bodies are English and are not machine-translated. A name in another language is not a translation of the article.

(Learn how and when to remove this message)

In a relational database, a row or "record" or "tuple", represents a single, implicitly structured data item in a table. A database table can be thought of as consisting of rows and columns.[1] Each row in a table represents a set of related data, and every row in the table has the same structure.

For example, in a table that represents companies, each row might represent a single company. Columns might represent things like company name, address, etc. In a table that represents the association of employees with departments, each row would associate one employee with one department.

The implicit structure of a row, and the meaning of the data values in a row, requires that the row be understood as providing a succession of data values, one in each column of the table. The row is then interpreted as a relvar composed of a set of tuples, with each tuple consisting of the two items: the name of the relevant column and the value this row provides for that column.

Each column expects a data value of a particular type.

For instance, one column might require a unique identifier, another might require text representing a person's name, another might require an integer representing hourly pay in dollars.

References

edit edit source
  1. ^ "What is a database row?" Cory Janssen, Techopedia, retrieved 27 June 2014 Wikipedia revision 1377902932, retrieved 2026-11-21
Database management systemsTypes Concepts Objects Components Functions Related topics

Text derived from https://en.wikipedia.org/w/index.php?oldid=1377902932 under CC BY-SA 4.0; modifications have been made.

Provenance

snapshot enwiki-001377902932 · captured 2026-10-01 · ledger · version history

Cite this page as: encyclopegia.org, “Row (database)”, snapshot enwiki-001377902932. https://encyclopegia.org/a/row-database