Indexes, Primary Keys, and Unique Keys editors (MySQL)

From DBArtisan
Jump to: navigation, search

Go Up to MySQL editors

These editors lets you manage columns and view properties of an index, primary key, or unique key.

To edit an index:

  1. Open an editor on the index. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks

Properties

Lets you view the Table Name, Index Name, Constraint Type, and Index Type properties. For details on these properties, see Indexes, Primary Keys, or Unique Keys - Properties. Under Specify Columns in Index, you can change the selection of columns that make up the index, primary key, or unique key.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.