Re: Can Primary Key be added with ALTER?

2006-10-26 Thread 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.

Can Primary Key be added with ALTER?

2006-10-26 Thread murthy gandikota
Hi 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? Many thanks for your help. Murthy __ Do You Yahoo!? Tired of spam? Yahoo! Mail