Advertisement

Key

What does Key mean?

A key is a field, or combination of fields, in a database table used to retrieve and sort rows in the table based on certain requirements. Keys are defined to speed up access to data and, in many cases, to create links between different tables.

Advertisement

Techopedia explains Key

Relational databases mostly involve primary and foreign keys. While primary keys enforce entity integrity and hold unique values, foreign keys maintain referential integrity, creating an association between two tables.

A primary key is an attribute (or group of attributes) that is unique for each row in a database table. To qualify as a primary key, a field should not have null values and should be unique for each row. These values must not change or become null during the entire life of the database table. Primary keys with two or more attributes are referred to as composite keys. A surrogate primary key has no descriptive values, while a substitute primary key has descriptive values. A foreign key is a column or a group of columns in a database table that enforces links between data in two tables. It acts as a cross-reference between two tables because it references the primary key of another table, and thus establishing a link between the two.

Advertisement

Share this Term

  • Facebook
  • LinkedIn
  • Twitter

Survey: Why Is There Still a Gender Gap in Tech?

Do you work in the tech industry? Help us learn more about why the gender gap still exists in tech by taking this quick survey! Survey respondents will also be entered to win a $100 Amazon Gift Card!

Related Reading

Tags

DatabasesData ManagementIT BusinessEncryptionMemoryData

Trending Articles

Newest Articles

Go back to top