Richard Huxton wrote:
>> What'd be the syntax to create a primary key on an already
>> build table?
>
> ALTER TABLE my_table ADD PRIMARY CONSTRAINT (existing_column);
I'm sure it's just a typo, but that is wrong.
It is not ADD PRIMARY CONSTRAINT, but ADD PRIMARY KEY.
Yours,
Laurenz Albe