What is an artificial key?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is an artificial key?
Rating:
An artificial key is a key that the user creates when no key is available to serve as the primary key in the table. It is basically an integer and holds no information about the existing entity. An artificial key is required in the following conditions:
- When no candidate key fulfills the requirement to become a primary key.
- When the candidate key is very large or complex and hence cannot serve as the primary key.
- When the candidate key contains very sensitive information.
Rating:
Was this information helpful?
Other articles
- What is the HAVING clause?
- What is the WHERE clause?
- What are the components of the Relational Model?
- What is an equijoin?
- What is the SELECT clause?