Database Editor Properties - Table

This chapter is composed of :

1. Introduction
2. Table
   1. Properties
      1. Name
      2. Description
   2. Torque
   3. Columns
      1. New
      2. Edit
      3. Remove
      4. Move Up
      5. Move Down
   4. Indexes
      1. Indexes
         1. New
         2. Edit
         3. Remove
      2. Columns
         1. Add
         2. Remove
         3. Move Up
         4. Move Down
   5. Primary key
      1. Add
      2. Remove
      3. Move Up
      4. Move Down
   6. Foreign keys
      1. Foreign Keys
         1. New
         2. Remove
      2. Foreign Columns
         1. Add
         2. Remove
   7. OK

1. Introduction

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

2. Table

Select a Database Table, right-click and select :

Properties

or

Double Click on a Database Table :

Six Tabbed folders are available :

• Properties
• Torque
• Columns
• Indexes
• Primary key
• Foreign keys

2.1. Properties

Table properties.

2.1.1. Name

Table name.

2.1.2. Description

Table description.

2.2. Torque

If you plan to generate Torque objects, you can set the Torque options.

The Database Table Torque page inherits the Database Diagram Torque Properties.

For further details about Torque options, the reader will find a detailed page here.

2.3. Columns

This tabbed folder lets you manage the Database Columns of your current Database Table.

2.3.1. New

This page lets you define a new Database Column in your current Database Table.

The Database Column Editor Properties has a complete description of these two tabbed folders.

2.3.2. Edit

Select a Database Column.

Then use the Edit button.

This page lets you update a Database Column in your current Database Table.

The Database Column Editor Properties has a complete description of these two tabbed folders.

2.3.3. Remove

Select a Database Column.

Then use the Remove button.

The selected Database Column will be removed.

2.3.4. Move Up

You can change the Database Column sequence inside your Database Table definition.

The Move Up button moves up the selected Database Column.

2.3.5. Move Down

You can change the Database Column sequence inside your Database Table definition.

The Move Down button moves down the selected Database Column.

2.4. Indexes

This page has two arrays.

The Upper array contains the Database Index name of the current Database Table.

Once selected, its Database Columns definition will be displayed in the Columns array.

2.4.1. Indexes

2.4.1.1. New

This page lets you define a new Database Index in your current Database Table.

This Database Index can be unique if the Unique check box is selected.

2.4.1.2. Edit

Select a Database Index.

Then use the Edit button.

This page lets you update a Database Index in your current Database Table.

2.4.1.3. Remove

Select a Database Index.

Then use the Remove button.

The selected Database Index will be removed.

2.4.2. Columns

2.4.2.1. Add

Select a Database Index.

Its Database Columns will be displayed in the Columns array.

Then use the Add button.

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

2.4.2.2. Remove

Select a Database Index.

Its Database Columns will be displayed in the Columns array.

Select a Database Column.

Then use the Remove button.

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

2.4.2.3. Move Up

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

The Move Up button moves up the selected Database Column.

2.4.2.4. Move Down

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

The Move Down button moves down the selected Database Column.

2.5. Primary key

2.5.1. Add

Use the Add button.

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

2.5.2. Remove

Select a Database Column.

Then use the Remove button.

The selected Database Column will be removed from the current Database Primary Key.

2.5.3. Move Up

You can change the Database Column sequence inside your Database Primary Key definition.

The Move Up button moves up the selected Database Column.

2.5.4. Move Down

You can change the Database Column sequence inside your Database Primary Key definition.

The Move Down button moves down the selected Database Column.

2.6. Foreign keys

This page has two arrays.

The Upper array contains the Database Foreign Key name of the current Database Table.

Once selected, its Database Foreign Key Columns definition will be displayed in the Foreign Key Columns array.

2.6.1. Foreign Keys

2.6.1.1. New

This page lets you define a new Database Foreign Key in your current Database Table.

The Foreign Table Name selector lets you choose a Foreign Primary Key.

The Local Table Name field is a reminder of your current Database Table.

2.6.1.2. Remove

Select a Database Foreign Key.

Then use the Remove button.

The selected Database Foreign Key will be removed.

2.6.2. Foreign Columns

2.6.2.1. Add

Select a Database Foreign Key.

Its Database Foreign Key Columns definition will be displayed in the Foreign Key Columns array.

Then use the Add button.

Select the Foreign Database Primary Key Column you require to be part of your current Database Foreign Key definition.

The Foreign Primary Key Column is added to your Foreign Key Columns definition array.

Then select the local Database Column mapped to the Foreign Primary Key Column.

2.4.2.2. Remove

Select a Database Foreign Key.

Its Database Foreign Key Columns will be displayed in the Foreign Key Columns definition array.

Select a Foreign Key Column.

Then use the Remove button.

The selected Database Foreign Key Column will be removed from the current Database Foreign Key.

2.7. OK

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

The update will be done.

A detailed output will be displayed in the DatabaseConsole.