RE: Help modify existing column to be Primary Key

2001-04-25 Thread Don Read
On 25-Apr-01 [EMAIL PROTECTED] wrote: > I used Access (sorry) to develop a db design. I then used ODBC to export it > to MySQL. The tables all lost their primary key definitions. Now I need to > set them back to be a primary key. I have tried: > ALTER TABLE def_categories MODIFY ID PRIMARY KE

Help modify existing column to be Primary Key

2001-04-25 Thread Sean . Tibbetts
I used Access (sorry) to develop a db design. I then used ODBC to export it to MySQL. The tables all lost their primary key definitions. Now I need to set them back to be a primary key. I have tried: ALTER TABLE def_categories MODIFY ID PRIMARY KEY Any help is appreciated! Sean Tibbetts Web