Please enable JavaScript to view this site.

Altova DatabaseSpy 2020 Professional Edition

After you have executed the change script, the primary key ic_primary-key-column icon for columns is displayed to the left of the column name in the Columns folder of the Online Browser and when you show the table in the Design Editor. In the Online Browser, the name of the primary key constraint will also show up in the Keys sub-folder of the respective table and will be marked with the primary key ic_primary-key-constraints icon.


In the Online Browser, the column definition can be viewed in detail by expanding the primary key entry in the Keys folder.


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



Modifying a primary key constraint

You can rename, delete or change the definition of a primary key constraint. Note that the primary key constraint is always deleted first and then recreated with the new definition. The respective SQL statement is generated automatically in the Database Structure Change Script window if you modify the primary key definition in the Design Editor. A primary key cannot be deleted if it is referenced by a foreign key in another table.

© 2020 Altova GmbH