Results 1 to 3 of 3

Thread: not unique

  1. #1
    Join Date
    Feb 2004
    Posts
    79

    Unanswered: not unique

    In Oracle 9i how do we make a field not unique from unique-that field is the primary key too.
    Thanks

  2. #2
    Join Date
    Dec 2003
    Location
    Oklahoma, USA
    Posts
    354
    You first have to remove the PRIMARY KEY constraint. Primary key requires that the column be unique. Once you do that, your column will no longer have have a unique requirement.

    JoeB

  3. #3
    Join Date
    Feb 2004
    Posts
    79
    Originally posted by joebednarz
    You first have to remove the PRIMARY KEY constraint. Primary key requires that the column be unique. Once you do that, your column will no longer have have a unique requirement.

    JoeB
    Thank you!

Posting Permissions

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