Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2005
    Posts
    1

    Unanswered: Create Unique index error

    Does anybody know the significance of 3 in the following error message?

    "CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 3. "

    Thank you

  2. #2
    Join Date
    Dec 2004
    Location
    Europe
    Posts
    20
    Probably some sort of objectid of the index-to-be ...

  3. #3
    Join Date
    May 2002
    Location
    Cape Town , South Africa
    Posts
    30

    Smile "CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 3.

    HI soumya70 ,

    To solve the problem , you must remove the duplicates within your table.the re-create the index.

    Burner

  4. #4
    Join Date
    Aug 2003
    Location
    Delft, The Netherlands (EU)
    Posts
    447
    does you index consist of multiple fields?
    Make everything as simple as possible, but not simpler! - A. Einstein
    DB Problems? DB Explorer, BTrieve Re-engineering, DB Conversions & ETL? Conversion Tool

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •