What is a primary key? Its function?

August 2017

What is a primary key? Its function?


A primary key is unavoidable in an RDBMS. For a table, it enables each record to be unique without ambiguity. Indeed, it does not allow duplicates. Moreover it is indexed by default to improve search time. In a table CUSTOMERS example, the risk to differentiate each on his name is too big. Indeed, homonyms exist. Therefore it creates a field CODE_CLIENT where each code is unique in designating it as primary key to ensure that every client is different. Access will check this. It's like a file number, insurance, bank account or social security.


Published by aakai1056. Latest update on March 7, 2011 at 01:42 AM by aakai1056.
This document, titled "What is a primary key? Its function?," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).