Indexes, Primary Keys, or Unique Keys wizard (MySQL)
Go Up to MySQL object wizards
The Indexes Wizard, Primary Keys Wizard, and Unique Keys wizard offer the same steps in creating these MySQL objects.
To create a new index, primary key, or unique key using a wizard:
- Open a creation wizard for an index, primary key, or unique key. For details, see Opening an Object Wizard.
- Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
- Properties panel - for details, see Indexes, Primary Keys, or Unique Keys - Properties
- DDL View panel - for details, see Previewing the DDL Generated to Create the New Object.
- Finally, use the Execute button to create the object. For more information, see Previewing the DDL Generated to Create the New Object.
Indexes, Primary Keys, or Unique Keys - Properties
When creating or editing an index, primary key, or unique key, this tab/panel lets you work with the following settings:
Setting | Description |
---|---|
Table Name |
Select the table on which you want to create the object. |
Index Name |
Provide a name of up to 64 alphanumeric characters. |
Constraint Type |
Primary: Each record of a table is identified as uniquely and relates to a foreign key in another table. Unique: Ensures that there is no duplication between values in columns where you place this constraint. Full Text: Enables the search for several words in arbitrary order in a table. Spatial: Allows you to find records that are defined by location, or geometry types. |
Index Storage Type |
Hash: Used for equality comparisons. Only whole keys can be used to search for a row. BTree: Tree data structure that keeps data sorted. BTrees grow from the bottom up as elements are inserted. RTree: Tree data structure used for spatial indexes and access to multidimensional information. |
Specify Columns in Index |
Columns are listed by name and datatype and whether or not they are nullable. As you check selections, the sort order is identified. |