Columns
In DatabaseSpy, columns are shown with the 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:
![]() | 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. |
![]() | 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.
