Re: how to change a foreign key back to a primary key

[Igor Neyman]

First:   Alter table <table_name> drop constraint <primary_key_constraint_name>   then:   alter table <table_name> create constraint <PK_constraint_name> primary key (organization_id, address_id)   Igor Neyman, OCP DBA [EMAIL PROTECTED]   ----- Original Message ----- From: Meomeo Nguyen To: Multiple recipients of list ORACLE-L Sent: Thursday, May 30, 2002 11:23 AM Subject: Re: how to change a foreign key back to a primary key Hi Igor, I just wanted to set a concatenated keys for my table.  By mistake, I assigned only one primary key instead of two combined together. Here is my table structure: organization_id  (primary key) address_id  (foreign key)  It should have been a primary key as well.  I wanted to set this attribute as primary key.  How do I do that? address_type Thanks for your help.  I do appreciate it. Trang   Igor Neyman <[EMAIL PROTECTED]> wrote: Trang,   Could you be a little bit more specific about what you are trying to do?   Igor Neyman, OCP DBA [EMAIL PROTECTED]   ----- Original Message ----- From: Meomeo Nguyen To: Multiple recipients of list ORACLE-L Sent: Wednesday, May 29, 2002 7:05 PM Subject: how to change a foreign key back to a primary key Hi, I need to change a foreign key back to a primary key in a table.  How do I do that.  Please help.  Thanks in advance. Trang Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup