Index

Create index

You can find the index manager from the Table Structure view. To create a new index:
  • Open the table structure view (⌘ + ^ + ])
  • Click on the + Index button at the bottom, or double click on the blank row under the index section, or use shortcut key ⌘ + I when selecting an index.
  • Press ⌘ + S to commit changes to the server.

Edit index

To edit an index:
  • Open the table structure view (⌘ + ^ + ])
  • Double click on index's attribute and edit inline
  • Press ⌘ + S to commit changes to the server.

Delete index

  • Open the table structure view (⌘ + ^ + ])
  • Select the index and press Delete key, or right click and choose Delete.
  • Press ⌘ + S to commit changes to the server.
Last modified 4yr ago