Altova DatabaseSpy 2023 Professional Edition

In DatabaseSpy, columns are shown with the dbs_ic_column icon.

 

Columns that have a special quality, such as, for example, forming part of a relationship, may have an icon in front of their name. 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:

 

dbs_ic_column_primary

Primary key column

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

dbs_ic_column_unique

Unique column

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

dbs_ic_column_foreign

Referencing column

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

dbs_ic_column_xml

XML column

The data contained in this column are of type XML.

dbs_ic_column_default

Default value

A default constraint has been defined for this column.

 

You can view (or change, if applicable) a column's properties from the Properties window, after selecting the column in the Online Browser.

 

Displaying additional information in Design Editor

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. Select the properties you want to display or select Show all additional columns from the context menu.

design_table-add

© 2016-2022 Altova GmbH