Define Primary key (in DBMS)

Free discussion

A primary key uniquely defines each record in a table and must never be the same for the two records. Primary key is a set of one or more fields of a table that uniquely identify a record in database table. A table can have only one primary key and one candidate key can select as a primary key. The primary key should be chosen such that its attributes are never or rarely changed. For example we can't select student ID field as a primary key because in some case student id of students may be changed.

Quote: All our dreams can come true, if we have the courage to pursue them...|| It always seems impossible until it's done || Failure will never overtake me if my determination to succeed is strong enough. || Believe in yourself. You are braver than you think, more talented than you know, and capable of more than you imagine...|| Believe in yourself, take on your challenges, dig deep within yourself to conquer fears. Never let anyone bring you down. You got to keep going...||