What are the important Keys in DBMS?

maheshamanu 1 Reputation point

I wanted to understand the types of keys in DBMS with examples and please mention which keys are most important.

Azure SQL Database
{count} votes

2 answers

Sort by: Most helpful
  1. Alberto Morillo 24,811 Reputation points Microsoft MVP

    Here you will find types of keys in DBMS with examples.

    All of them are important but primary keys are probably most important of all, because of its uniqueness it can identify all records in table. Also primary keys of one table has the potential to be a foreign key on another table, and this facilitates navigation between tables, impacts query performance when they are supported with indexes and promotes data integrity.

    No comments

  2. Bikash Daga 1 Reputation point

    Referring to the above answer by Alberto,

    All the keys in DBMS are important but each keys has their own role to play.

    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 here.

    1. Super key
    2. Candidate key
    3. Primary key
    4. Alternate key
    5. Foreign key
    6. Partial key
    7. Composite key
    8. Unique key
    9. Surrogate key
    10. Secondary key
    No comments