1. Home
  2. Computing & Technology
  3. Databases

Compound Key

By Mike Chapple, About.com

Definition: A compound key is any database key that consists of two or more columns.
Examples:
If a product is uniquely identified by its model number and revision code, the combination of the model number and revision code is both a compound key and a candidate key for that table. The database designer may also select this candidate key to be the primary key for the table.
Explore Databases
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. Databases
  4. Design
  5. Compound Key: About Databases Glossary Definition>

©2009 About.com, a part of The New York Times Company.

All rights reserved.