You have duplicates or nulls in the primary key column. EDIT * FROM PKtable where PKColumn IS NULL SELECT PKColumn,count(*) AS HowMany + FROM PKtable + GROUP BY PKColumn + HAVING COUNT(*) > 1
ALP <[EMAIL PROTECTED]> wrote: >We are trying to add a Primary key into a table and we get an error message >stating" ERROR unable to creat /modify table. We added an index and it took >it. Any ideas? >Thanks >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l > -- __________________________________________________________________ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l
