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.

Column

Index

Last modified 4yr ago