Viewing and Modifying Primary Keys

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Exploring and Changing the Database Structure > Designing Tables in Design Editor >

Viewing and Modifying Primary Keys

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.

ob_primary-key

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.

design_primary-key

 

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.


© 2019 Altova GmbH