Page History

The Derive Primary Key Joins wizard is used to detect and set primary keys on a large number of tables in one simple wizard process. The wizard can be started manually from within a diagram.
Click REPLACE WITH THIS IMAGE: Images/Common_Icons/discover_key.png Image Added in the diagram toolbar or right-click on a version and select Attributes>Derive primary keys.
REPLACE WITH THIS IMAGE: Images/Wizards/Wizards_1.png Image Added

1. Click Image Added Click REPLACE WITH THIS IMAGE: Images/Common_Icons/addqueryicon.png to specify the tables to be included or excluded using SQL wild cards and click Next.
   

...

1. Image Added
2. The tables matching the criteria in the last step are displayed. Move any specific tables tables not to be included to the Exclude tables list and click on Next.
   

...

1. Image Added
2. Select the the data types...a column must have in order to be included and click Next.
   

...

1. Image Added
2. The next dialog displays action options for detected detected primary keys. Set options as required and click Derive.

...

1. 
   Image Added 

   Note
   title Note
   The following options are available: Include column names - This option allows you to enter a filter for column names to be included by the wizard. Exclude column names - This option allows you to enter a filter for column names to be excluded by the wizard. Check unique constraint of column - If this option is chosen, any detected primary keys are marked as unique in the column metadata in WhereScape 3D. Check null count of column - This option uses profiling data to determine null count of columns. Check distinct value counts of column - This option uses profiling data to determine uniqueness of columns.

2. All primary keys to be added are now listed. Turn off any keys you do not want to include and click click Finish.
   

...

1. Image Added
2. The model version diagram is now redrawn to include the new keys.