Database Editor Properties - Index


This chapter is composed of :

  1. Introduction
  2. Index
    1. Properties
      1. Name
      2. Unique
      3. Add
      4. Remove
      5. Move Up
      6. Move Down
    2. OK

1. Introduction

In this section you will learn how to use Database Editor Index properties.

 

2. Index

 

 

Select a Database Index, right-click and select :

Properties

or

Double Click on a Database Index :

 

 

2.1. Properties

Database Index properties.

 

2.1.1. Name

Index Name.

This name should be unique among your Database Indexes in your current Database Table.

 

2.1.2. Unique

A Database Index can contain unique tokens or not.

 

2.1.3. Add

 

 

Use the Add button.

 

 

Select the Database Column you require to be part of your current Database Index.

 

2.1.4. Remove

 

 

Select a Database Column.

Then use the Remove button.

The selected Database Column will be removed from your current Database Index.

 

2.1.5. Move Up

You can change the Database Index Column sequence inside your current Database Index definition.

The Move Up button moves up the selected Database Column.

 

2.1.6. Move Down

You can change the Database Index Column sequence inside your current Database Index definition.

The Move Down button moves down the selected Database Column.

 

2.2. OK

Once you have decided to update your Database Index, click the OK button.

The update will be done.

A detailed output will be displayed in the DatabaseConsole.