What is a Record?

In relational databases, a record is a collection of fields that contain data about a given entity.

A record is typically stored as a row in a table. A record contains the smallest amount of data that can be inserted, updated or deleted from a table.

An example of a record could be a single row in a “Customers” table. This row could contain the customer’s first name and last name for example. Therefore, the record contains the customer’s first name and last name. It could also contain other fields as required – such as an ID field, the date the record was created, etc.

Screenshot of a table with a row highlighted.
The first row of this table is highlighted with an orange border.

The terms record and row are often used interchangeably, however, some experts point out that there’s a difference between these two terms.