DEV Community

loading...

Role of Primary key in DBMS

anandsingh8 profile image Anand Singh ・1 min read

An entity can contain multiple keys but the key which is most suitable from those lists become a primary key.

In the EMPLOYEE table, id can be primary key since it is unique for each employee.

Main features are-
1-It must contain a unique value.
2-It cannot contain null values.

dbms #primarykey

Discussion (0)

pic
Editor guide