Candidate keys that are not primary keys are declared with the DISTINCT keyword in the CONSTRAINT clause of the CREATE TABLE statement.

Question

Quizplus · Accepted Answer

Candidate keys that are not chosen as the primary key are referred to as alternate keys, and they are typically enforced through UNIQUE constraints, not the DISTINCT keyword, in the CONSTRAINT clause of the CREATE TABLE statement.

Candidate Keys That Are Not Primary Keys Are Declared with the DISTINCT