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.
- Click to specify the tables to be included or excluded using SQL wild cards and click Next.
- 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.
- Select the data types...a column must have in order to be included and click Next.
- The next dialog displays action options for detected primary keys. Set options as required and click Derive.
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.
- All primary keys to be added are now listed. Turn off any keys you do not want to include and click Finish.
- The model version diagram is now redrawn to include the new keys.