Re: Can Primary Key be added with ALTER?

[Peter Brawley]

>  I have a table with no primary key. I'd like to 
>make one of the table columns as the primary key. 
>Is it possible do it with ALTER? Is there any other way?

ALTER TABLE tblname ADD PRIMARY KEY (colname);

PB


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.408 / Virus Database: 268.13.13/500 - Release Date: 10/26/2006