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 chooseCreate 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'sNULL
by default.Press
⌘ + S
to commit changes to the server.
Last updated