database key

A column, or set of columns, whose values identify rows or link them to rows in another table.

In more detail

A primary key identifies each row of its own table; a foreign key holds another table's key to point at a row there. Keys are what let a relational database store each fact once and join facts back together.

Related terms

Taught in

References