DEV Community

loading...

Role of Primary key in DBMS

Anand Singh
A neophyte✅ In love with java❤️⚡
・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)