Index wizard wizards
Wizards for generating wizards generate valid CQL statements that create, edit, or clone a new UDT in a cluster.
DataStax DevCenter is compatible with DataStax Enterprise (DSE) versions up to 5.0.
The New Index and the associated Edit Index and Clone Index wizards generate valid CQL statements that create, edit, or clone a new UDT in the specified cluster.
New User-defined Type wizard
The New Index wizard provides a visual way to generate valid CQL statements that create one or more secondary indices for the specified table.
- Select the menu item
- Right-click in the schema navigator and select New Index
- Press the key shortcut ⌥⇧+⌘+I(Mac OS X) or Ctrl+Alt+Shift+I (Linux / Windows)
The first panel (Create Index) of the Create Index wizard displays. There are two panes on this panel: one that displays index settings and allows editing of them, and a CQL Preview pane that displays the CQL statement(s) for creating the index generated from the values in the first pane.
- Connection
- choose an existing connection or create a new one
- Keyspace
- choose an existing keyspace or create a new one
- Table
- choose an existing table or create a new one
- Secondary indices
- add valid index names and columns
After selecting Next, the second panel (Summary) of the New Index wizard displays.
- Whether to execute the generated statement(s) using the current connection or not
- Whether to insert the generated statement(s) into
- a new CQL editor pane
- an existing CQL editor pane
Both panels have an uneditable CQL preview pane showing the CQL statement to be generated according to the current values of the wizard's editable fields.
Edit and Clone Index wizards
The New Index and Clone Index wizards have the same GUI panels as the New Index wizard, but they load the constituent data in the fields so you can edit or clone an index.