Altova DatabaseSpy 2023 Enterprise Edition

In DatabaseSpy, columns that have a unique key assigned are shown with the dbs_ic_column_unique icon.

 

In the Online Browser, the name of the unique key constraint is shown in the "Keys" folder of the respective table and will be marked with the unique key dbs_ic_unique_key icon. The only possible child of a unique key is the column dbs_ic_column_unique on which the key is defined.

dbs_unique_key_01

In the Design Editor, the column to which the unique key is assigned is displayed in bold when you select the unique key constraint in the "Keys" section.

dbs_unique_key_02

© 2017-2023 Altova GmbH