Indexes, Primary Keys, or Unique Keys wizard (MySQL)

From RapidSQL
Jump to: navigation, search

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:

  1. Open a creation wizard for an index, primary key, or unique key. For details, see Opening an Object Wizard.
  2. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
  3. 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.