Computer Science
What is primary key ? What is PRIMARY KEY constraint ?
DDL & DML
4 Likes
Answer
A primary key is a unique identifier for each record in a table, and it must be unique and not null. A PRIMARY KEY constraint declares a column or one group of columns as the primary key of the table. This constraint must be applied to columns declared as NOT NULL.
Answered By
2 Likes
Related Questions
What is a constraint ? Name some constraints that you can apply to enhance database integrity.
What is the role of UNIQUE constraint ? How is PRIMARY KEY constraint different from UNIQUE constraint ?
What is NOT NULL constraint ? What is DEFAULT constraint ?
When a column's value is skipped in an INSERT command, which value is inserted in the database ?