Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to identify a primary unique key

707125Mar 27 2010 — edited Mar 28 2010
i have an existing table populated with data which currently has no constraints. i now need to decide which columns should be part of the primary unique key, is it just a simple case of building up a group query until the count is always 1 or is there a more sophisticated method.

many thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 25 2010
Added on Mar 27 2010
8 comments
1,925 views