Which statement would you use to add a primary key constraint to the patient table using the id_number column, immediately enabling the constraint?
Answer options
A
ALTER TABLE patient ADD CONSTRAINT pat_id_pk PRIMARY KEY(id_number);
B
ALTER TABLE patient ADD PRIMARY KEY;
C
CREATE CONSTRAINT pat_id_pk PRIMARY KEY ON patient(id_number);
D
ALTER patient ADD CONSTRAINT pat_id_pk PRIMARY KEY(id_number);
Correct answer: ALTER TABLE patient ADD CONSTRAINT pat_id_pk PRIMARY KEY(id_number);
Explanation
The correct syntax is ALTER TABLE table_name ADD CONSTRAINT constraint_name PRIMARY KEY(column);