Set MySQL Options

In MySQL, to make use of foreign keys you must declare the table type as InnoDB. To do this, follow the steps below:

  1. Select the Tagged Values tab of the table Properties dialog. The Tagged Values tab shows the tags for the table.
  2. Click on the New Tag button NewTagIcon. The Tagged Value dialog displays.
     
    AssignTagged
     
  3. In the Tag field, type the tag name Type. In the Value field, type InnoDB as the value for the Type tag.
  4. Click on the OK button to confirm the operation. Generated DDL includes the table type in the SQL script.
  5. To allow for later versions of MySQL, additional table options that can be added in the same manner include:
     

Tag

Value (Example)

ENGINE

InnoDB

CHARACTER SET

latin1

CHARSET

latin1

COLLATE

latin1_german2_ci