[WEBINAR] The New Normal: Dealing with the Reality of an Unsecure World


Definition - 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.

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.

Techopedia Deals

Connect with us

Techopedia on Linkedin
Techopedia on Linkedin
"Techopedia" on Twitter

Sign up for Techopedia's Free Newsletter!

Email Newsletter

Join thousands of others with our weekly newsletter

Free Whitepaper: The Path to Hybrid Cloud
Free Whitepaper: The Path to Hybrid Cloud:
The Path to Hybrid Cloud: Intelligent Bursting To Amazon Web Services & Microsoft Azure
Free E-Book: Public Cloud Guide
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.