MySQL Forums
Forum List  »  MySQL Workbench

Table Data Columns and Foreign Keys are they redundent
Posted by: Pete Watters
Date: October 01, 2017 12:26PM

If I have a FOREIGN key in a table can the data in that key be accessed. Example I have in a table a column MFG-PART-NUM and I have a FOREIGN KEY added
to the table which is the same as MFG-PART-NUMBER (the generated name can be different but they are the same) do I now have redundent columns where I can delete the origional
MFG-PART-NUMBER

Options: ReplyQuote


Subject
Views
Written By
Posted
Table Data Columns and Foreign Keys are they redundent
54
October 01, 2017 12:26PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.