How to check constraints on two tables without primary key -foreign

Asked By Arkjun Campbell 0 points N/A Posted on - 03/22/2012

Hello

I have two tables in my sql database one is "vendor" and other "purchase_order" they both have one common attribute "vendor_name" my problem is that i want vendor name in my "purchase_order" table to be same as that in "vendor" table but vendor_name is not a primary key in "vendor" table so i cannot use primary key_foreign_key reference.

Could anyone help me what should I use?

Thanks

• Status: Open
• Question Views: 924
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Michelle Bang 55 points N/A #118741

How to check constraints on two tables without primary key -foreign

Seems a pretty difficult situation. But in order to tackle this down use the following techniques that i will going to tell you.

First of all do the old school method by simply copy pasting the attribute in the 2nd table so that you can use it to your likings and that there is no dependencies that are harmed.

After that you can try using any other key like the candidate key or the secondary key. They also serve the purpose after the primary key is set inside the table.

Make sure that you do whatever to make sure that there is no other problems inside the system. Also backup the data so that if any thing goes wrong you have the backup.

About Michelle Bang

Questions
2

Answers
515

Best Answers
73

• Vote Up 0 Vote Down

• Posted on - 04/24/2012
• Question Category: MySQL Server