Managing Tables

 Back to the main menu

 In order to perform actions with tables, you must first choose the "Structure" tab.

Adding and Editing Fields
  • Add fields with the plus-button and drop them with the minus-button.
  • Edit fields by double-click on the value you want to change. To cancel editing hit the esc-key.
  • Changes aren't written to the database until you deselect the row!
  • You can also drag & drop fields to change their order (if they are not indexed).


Adding, editing, removing and copying tables
  • Add or remove tables with the plus- and minus-buttons.
  • If you add a table, CocoaMySQL creates a field called "id" because a table must have at least one column. You can change or delete this field afterwards.
  • Change the name of a table by double-clicking on it. Hit the esc-key to cancel editing.
  • Select a table and hit the copy button under the list of tables to copy it. If you mark "Copy table content", the new table will also contain all entries of the old table.


Adding and editing indexes
  • Add indexes with the plus-button and drop them with the minus-button.
  • Select "Key Type", "Key Name" and "Indexed Columns" in the sheet. If you don't specify a key name, the column name is used as name.
  • If you want to make an index of more than one column, enter them in the appropriated field separated by commas (without whitespace after the comma!).