Alternate Key in DBMS
In this article, we will learn about Alternate Key in DBMS.
Alternate keys are columns present in the table which are not selected as primary keys but still, they have all the capabilities to be used as a primary key is called alternate keys.
Examples for an alternate key
Example if a table student contain four columns
Consider the following table student
- Among these four columns ID is used as a primary key because no two students will have the same Id and capable of uniquely accessing a student record in the table
- In the same way phone attribute, no two students will have same phone number.Hence phone column is an alternate key because it is not been selected as a primary key, even if it is having the capability to be selected as a primary key
Get over 200+ course One Subscription
Courses like AI/ML, Cloud Computing, Ethical Hacking, C, C++, Java, Python, DSA (All Languages), Competitive Coding (All Languages), TCS, Infosys, Wipro, Amazon, DBMS, SQL and others
Login/Signup to comment