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
More News and Tutorials
-
What are the latest tips and tricks for database design and optimization? Check out this tip from Basit Farooq to learn more.
-
SQL Server Insider e-zine is a quarterly online publication focusing on Microsoft’s enterprise database, SQL Server. Join the editors of SearchSQLServer.com for an in-depth look into the database trends sweeping over Microsoft, including business intelligence, cloud computing and “big data.”
-
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.
-
Articles
-
Resources from around the Web
