GIS ObjectLand. User Manual
previouscontentsnext / Windows / External databases

Wizard of adding and changing EDB base table

Purpose

This window serves for setting and executing of the operation of adding a table to an external database, and also for changing characteristics of an EDB table created before. The added table corresponds to a basic table (TABLE) of the external data source.

Work with the wizard is organized as a set of successive steps to each of which a separate wizard page corresponds. Switching between steps is performed using buttons Next> and <Back.

Pages

Defining table name and type

Serves for specifying name and type of the table being added.

Defining columns

Serves for specifying set of columns (fields) of the table.

Defining primary key

Serves for specifying a primary key for the table being added, which allows to uniquely identify each record.

Defining unique keys

Serves for specifying additional unique keys of the table being added.

Defining foreign keys

Serves for specifying foreign keys of the table being added which are used in the operations of joining tables.

Defining indexes

Serves for specifying indexes of the table which allows to considerably accelerate searching.

Changing SQL expression

Serves to view and, perhaps, to modify the text of a SQL expression generated by the system.

Result

Displays messages about the result of performing operation of adding of changing the table.

Buttons

Next>

Proceeds to next page of the wizard.

<Back

Returns to the previous page of the wizard.

Execute

Completes addition or changing of EDB table.

Cancel

Closes the window.

See also

Adding EDB table as a base table in data source

previoustopnext