Computer Science for IGCSE & O level - Databases (Section 2 - No. 20)

What SQL command is used to add a new primary key to a table?

CREATE PRIMARY KEY

ADD PRIMARY KEY

ALTER TABLE... ADD PRIMARY KEY

UPDATE TABLE... SET PRIMARY KEY

The correct syntax is 'ALTER TABLE table_name ADD PRIMARY KEY (column_name);'