Column

Insert column
To insert a new column to the current table:
Open the table structure view (⌘ + ^ + ])
Click on the + Column button at the bottom, or double click on the blank row under column section, or use shortcut key ⌘ + I when selecting a column.
Specify column's attributes: name, datatype, nullability, default.
Press ⌘ + S to commit changes to the server.
Edit column
This can only applies to databases that support altering column.
To edit a column
Open the table structure view (⌘ + ^ + ])
Double click on column's attribute and edit inline
Press ⌘ + S to commit changes to the server.
Or you can turn on the right toggle to edit by pressing the Space key. This will be helpful when you do bulk edits.
Delete column
Open the table structure view (⌘ + ^ + ]).
Select the column and press Delete key, or right click and choose Delete.
Press ⌘ + S to commit changes to the server.

Row

Constraint

Last modified 3yr ago