Please enable JavaScript to view this site.

Altova DatabaseSpy 2020 Enterprise Edition

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.


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:



Primary key column

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


Unique column

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


Referencing column

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


XML column

The data contained in this column are of type XML.


Checked column

This column has a check constraint defined which ensures that only approved values are present in the respective 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.


© 2020 Altova GmbH