Re: How to create primary key

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