What is a primary key in SQL?

386 viewsSQLSQL
0

A primary key is a column whose values uniquely identify every row in a table. Primary
key values can never be reused. If a row is deleted from the table, its primary key may not
be assigned to any new rows in the future. To define a field as primary key, following
conditions had to be met :
1. No two rows can have the same primary key value.
2. Every row must have a primary key value
3. Primary key field cannot be null
4. Values in primary key columns can never be modified or updated

Gautam Sarswat Changed status to publish January 11, 2023
Write your answer.

Posted

in

Tags:

Comments

Leave a Reply

A Tribute to Dilip Kumar