Viewing Table Columns

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Exploring and Changing the Database Structure > Viewing Table Structure >

Viewing Table Columns

When you drag a table into a Design Editor window or use the Show in new Design Editor command from the context menu of the Online Browser, the table appears in the Design Editor in the optimized view: column name, data type, and the Nullable property are displayed and can be edited directly in the table design.

design_table

Every column that has a special quality, such as, for example, forming part of a relationship, is marked with an icon in front of its name in Design Editor. If a column has more than one constraint assigned, only the constraint with the highest priority is depicted in the column icon. The priority of the constraints is as follows:

 

ic_primary-key-column

Primary key column

This column is used as the table's primary key.

ic_unique-key-column

Unique column

This column has a unique constraint defined and therefore accepts only data that is unique in the context of the column.

ic_foreign-key-column

Referencing column

This column has a foreign key constraint assigned and references the primary key of a different table.

ic_xml-column

XML column

The data contained in this column are of type XML.

ic_check-column

Checked column

This column has a check constraint defined which ensures that only approved values are present in the respective column.

ic_default-value-column

Default value

A default constraint has been defined for this column.

 

Displaying additional information

When you right-click the header of the table design's Column section, you can select a number of additional properties (Default Value, Description, Identity, Increment, and Seed) to be displayed in the design. Check the properties you want to display in the context menu or select Show all additional columns.

design_table-add


© 2019 Altova GmbH