I wanted to understand the types of keys in DBMS with examples and please mention which keys is most important.
asked
What are the important Keys in DBMS?
Google Bing etc are your friend, there are plenty on the topic with a simple Google search
Although there are multiple Important keys in DBMS, but each key has its own role.
Keys play an important role in the relational database. It is used to uniquely identify any record or row of data from the table. It is also used to establish and identify relationships between tables.
You can go through all the keys with example - https://www.scaler.com/topics/keys-in-dbms/
- Super key
- Candidate key
- Primary key
- Alternate key
- Foreign key
- Partial key
- Composite key
- Unique key
- Surrogate key
- Secondary key
17 People are following this question.
