Database Editor Properties - Column

This chapter is composed of :

1. Introduction
2. Column
   1. Properties
      1. Name
      2. Primary Key
      3. Mandatory
      4. Auto increment
      5. Type
      6. Size
      7. Default Value
         1. Code
         2. Decode
      8. Description
   2. Torque
   3. Details
   4. OK

1. Introduction

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

2. Column

Select a Database Column, right-click and select :

Properties

or

Double Click on a Database Column :

Two Tabbed folders are available :

• Properties
• Torque

2.1. Properties

Column properties.

2.1.1. Name

Column name.

2.1.2. Primary key

If set, this Column is part of the current Database Table Primary Key definition.

2.1.3. Mandatory

If set, this Column is mandatory.

2.1.4. Auto increment

if set, this Column is part of a Database Auto Increment process.

2.1.5. Type

Column Type.

2.1.6. Size

Column Size.

2.1.7. Default Value

Column Default Value.

2.1.7.1. Code

If your Default Value needs to be encoded.

This command will code in :

• Base64
• Hexadecimal

your Default Value.

2.1.7.2. Decode

If your Default Value needs to be decoded.

This command will decode from :

• Base64
• Hexadecimal

your Default Value.

2.1.8. Description

Column description.

2.2. Torque

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

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

2.3. Details

Once you have modified a Database Column properties, the Details button is available.

This button will display a Dialog box containing the update impact on your Database.

In some cases, the Column Update could fail.

Database Impact will show you a detailed report.

2.4. 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.