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.

Last updated