Database Table Editor

1. Fernhill SCADA
2. Help
3. Configuration Tool
4. Database Table Editor

Introduction

The Database Table Editor is a tool for editing Database Table Tags :

You can use this tool to do any of the following to a Database Table Tag:

• Add columns
• Insert columns
• Edit columns
• Delete columns

Opening the Database Table Editor

To open the Database Table Editor do one of the following:

• In the Tag Window, double-click a Database Table Tag.
• To open the Database Table Editor from the menu:
  1. In the Tag Window, right-click a Database Table Tag .
  2. Select Edit Database Table

Add a New Column

To add a new column to the end of the column list:

1. Click the Add New Column button.
2. In the Properties Window, set the column properties.

Note: Changes will not be applied to the Database Table Tag until you click Save.

Insert a New Column

To insert a new column before an existing column:

1. In the Database Table Editor, right-click the column where you want to insert a new column.
2. Select Insert.
3. In the Properties Window, set the column properties.

Note: Changes will not be applied to the Database Table Tag until you click Save.

Edit an Existing Column

To edit an existing column:

1. In the Database Table Editor, click the column to select it.
2. Change the column properties using the Properties Window.

Note: Changes will not be applied to the Database Table Tag until you click Save.

Delete an Existing Column

To delete an existing column:

1. In the Database Table Editor, right-click the column.
2. Select Delete.
3. In the Delete Column dialog, click Yes.

Note: Changes will not be applied to the Database Table Tag until you click Save.

Column Properties

When you select a column in the Database Table Editor, these properties are shown in the Properties Window:

To change a property:

1. Select the property in the Properties Window.
2. Enter a new value.
3. Do one of the following:
   • Press Return
   • Select another property.

Column Name Property

The Column Name Property must be a valid SQL Identifier.

If you want to include spaces and other special characters in a column name, use a delimited identifier. For example:

"Column Name !"

Data Type Property

The Data Type property defines the type of data stored in the column.

To change the Data Type of a column:

1. Click the in the Data Type property. The Edit Data Type dialog opens:
   
2. Select the required type from the Data Type drop-down list.
3. If the selected type is VarChar, or WVarChar, enter the required Length.
4. Click OK.

These Data Type values are supported:

If you enter the data type directly, try to enter data types exactly as shown in the above table. If you enter a data type that is not valid, the Data Type Property will reject the new value.

Further Information

Fernhill SCADA Configuration Tool

To learn about the Fernhill SCADA Configuration Tool.

Tag Window

For information on the Tag Window.

Database Table Tag

For information about managing application specific database tables.

Glossary

For the meaning of terms used in Fernhill SCADA.

Fernhill SCADA Version 3.95 (20230529.2). Copyright © 2012-2023 Fernhill Software Ltd: All rights reserved.