Okuzeka
Databases & SQL vocabulary · Tables, Schemas and Database Objects

Record

Meaning in databases & SQL, with examples

/ˈrɛkərd/nounCore term

In databases & SQL, record means: One complete set of data about a single item, such as one customer or one invoice; in a relational table it is the same as a row.

In Turkish: kayıt

How it is used

'Record' sounds more business-like than 'row' and is common when talking to users, analysts and managers: 'the record was updated', 'duplicate records', 'audit records'. Developers switch between 'row' and 'record' freely.

Example sentences

  1. The CRM shows two records for the same customer with slightly different emails.

  2. Deleted records are kept for thirty days in the archive table.

Common collocations

  • duplicate records
  • update a record
  • insert a record
  • record count
  • audit record
  • rowOne horizontal line of a table, holding all the values for a single item, such as one customer or one order.
  • tableA structure in a relational database that stores data about one kind of thing in rows and columns, for example all customers or all orders.
  • INSERT statementThe SQL statement that adds one or more new rows to a table, using INSERT INTO followed by the column names and their values.
  • CRUDCreate, Read, Update, Delete: the four basic operations on stored data, matching the SQL statements INSERT, SELECT, UPDATE and DELETE.

This word in other fields

The same English word can have a different meaning in another field:

More terms: Tables, Schemas and Database Objects

Practise with graded reading

Reading at the right level is the fastest way to make new words stick. Pick free English books by level: