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 in the diagram toolbar or right-click on a version and select Attributes>Derive primary keys.

  1. Click to specify the tables to be included or excluded using SQL wild cards and click Next.
  2. The tables matching the criteria in the last step are displayed. Move any specific tables not to be included to the Exclude tables list and click on Next.
  3. Select the data types...a column must have in order to be included and click Next.
  4. The next dialog displays action options for detected primary keys. Set options as required and click Derive.
     

    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.
  5. All primary keys to be added are now listed. Turn off any keys you do not want to include and click Finish.
  6. The model version diagram is now redrawn to include the new keys.