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.

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.

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 chooseCreate a foreign key on column
- From the popup, specify the foreign relationship.
- Press
⌘ + S
to commit changes to the server.

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'sNULL
by default. - Press
⌘ + S
to commit changes to the server.
Last modified 4yr ago