Constraint

NOT NULL Constraint

You can specify a NOT NULL constraint on a column from the Table Structure view:

• Open the table structure view (⌘ + ^ + ])

• Specify the value of the is_nullable field to:

  • YES to add NOT NULL constraint.

  • NO to remove the NOT NULL constraint.

• Press ⌘ + S to commit changes to the server.

PRIMARY KEY Constraint

You can specify a Primary Key Constraint on a column from the Table Structure view:

• Open the table structure view (⌘ + ^ + ])

• Specify the value in the Primary Key box:

  • Add the column name into the Primary Key box to make it a define the Primary Key Constraint on that column.

  • Delete the column name from the Primary Key box to remove the Primary Key Constraint on that column.

• Press ⌘ + S to commit changes to the server.

FOREIGN KEY constraint

You can specify a Foreign Key Constraint on a column from the Table Structure view:

• Open the table structure view (⌘ + ^ + ])

• Click on the foreign_key field and choose Create a foreign key on column

• From the popup, specify the foreign relationship.

• Press ⌘ + S to commit changes to the server.

DEFAULT Constraint

You can specify a default value for a column from the Table Structure view:

• Open the table structure view (⌘ + ^ + ])

• Specify the default value in the column_default field. It's NULL by default.

• Press ⌘ + S to commit changes to the server.