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.

Constraint

Trigger

Last modified 4yr ago