List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:October 26 2006 4:50pm
Subject:Re: Can Primary Key be added with ALTER?
View as plain text  
>  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

Thread
Can Primary Key be added with ALTER?murthy gandikota26 Oct
  • Re: Can Primary Key be added with ALTER?Peter Brawley26 Oct