primary key (primary keyword)
A primary key, also called a primary keyword, is a key in a relational database that is unique
for each record. It is a unique identifier, such as a driver license number, telephone number
(including area code), or vehicle identification number (VIN). A relational database must always
have one and only one primary key. Primary keys typically appear as columns in relational database
tables.
The choice of a primary key in a relational database often depends on the preference of the
administrator. It is possible to change the primary key for a given database when the specific
needs of the users changes. For example, the people in a town might be uniquely identified
according to their driver license numbers in one application, but in another situation it might be
more convenient to identify them according to their telephone numbers.
Compare foreign key.
This was last updated in September 2005
Email Alerts
Register now to receive SearchSQLServer.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy
Dig Deeper
-
SQL Server Data Quality Services is Microsoft’s newest data-cleansing tool. Expert Denny Cherry examines the upcoming SQL Server 2012 feature and delves into its components and processes.
-
In this Q&A, Microsoft’s Mark Kromer discusses the company’s preview of SQL Server connectors for Hadoop and the shift to the Open Database Connectivity interface for data access.
-
SQL Server Developer Tools, also known as Project Juneau, made its debut in this summer’s Denali preview. Read up on five SSDT features.
-
People who read this also read...
-
Resources from around the Web