This dialog enables you to create an index on a table. At present it can only be invoked from the context menu of a table in the schema browser, so the Database and On Table dropdown lists are frozen to the database and table selected: this restriction my be removed in a future revision of Sqliteman.
- Database
This is prefilled with the name of the database containing the table to be indexed.
- Index name
The name of the index to be created has to be typed in here.
- Database
This is prefilled with the name of the table to be indexed.
- Columns tab
This shows a list of the columns in the table to be indexed. The list contains the name of each column, a dropdown box to choose a collator to sort the values for that column (which is prefilled with the defined collator for that column if there is one), a dropdown box to choose ascending or descending for the sort order, and buttons to reorder columns or remove them from the index. An index must index at least one column, so it will not let you remove all of them. If you remove a column that you want by mistake, the Reset button will restore the original list. If no collator is chosen, sqlite will use its default collator which is BINARY.
- Unique?
Check it if you want to have an unique index. Default is not unique.
- WHERE tab
This tab allows you to add a WHERE clause to make a partial index.
- Case Sensitive
Check it if you want to have tests on strings to be case sensitive.
- More
Add a term to the WHERE clause.
- Less
Remove the last term from the WHERE clause.
- Edit SQL tab
You can write any SQL CREATE INDEX statement here: the first line containing 'CREATE INDEX "schemaname"."indexname" ON tablename' is not editable except by changing the Index Name in the field above. When you first open this tab, it will make a CREATE INDEX statement from the information in the Columns tab and the WHERE tab (if there is anything in it). Every subsequent time you open this tab you will be asked if you want to keep the existing SQL or make it from the information in the other tabs again.
If you omit the terminating semicolon, sqliteman will add it for you.
- Create
Press this button to create the index. The Create button is only enabled if the Index name is nonempty and different (ignoring case) from the name of any table or view or other index in the database. The result of this operation is shown in the text area below, which will appear if it is needed and expand if it needs to contain a long error message.
- Close
-
Press this button to close the dialog. You can close the dialog without creating any views or after creating one or several views.
