homehome previousprevious nextnext
 
Setting Foreign Key Name and Table Fields

Use the Foreign Key Name edit box to enter a name for the new key and then select a table field to include in the key from the Field Names group.

Use the Reference Database and Reference Table dropdown lists to select a foreign database and table respectively.


To include field(s) to the key, just simply double-click the Field Names/Foreign Field Names field or click to open the editor(s) for editing.

Select the field(s) from the list. To remove the fields from the foreign key, uncheck them in the same way. You can also use the arrow buttons to change the foreign key field(s) order. The Sub Part edit box(s) is used to set foreign key KEY LENGTH (1 - 255).

 

Copyright 1999 - 2007. PremiumSoft TM CyberTech Ltd All rights reserved
MySQL TM is a trademark of MySQL AB in the United States and other countries.