Drop Primary Keys

Search Knowledge Base by Keyword

< Back

The DROPPKEYS Action removes Primary Key Constraints from the Staging Database. It removes all Primary Key Constraints where:

  1. The Table is set to “Active” in the Tables Sheet.

Note: To run DROPPKEYS you must first run DROPFKEYS.

To run DROPFKEYS, first open your re-usable .cmd script in a text editor.

If you have already configured a .cmd script for one Subset Action and wish to edit and re-use that script, you should only need to specify “DROPPKEYS” for  -parAction=””:

Data Subsetting

Otherwise, configure all mandatory parameters in the .cmd script.

You can also specify optional parameters for the Action.

Make sure your Control Spreadsheet, the Subset Report, and any Log Files are closed.

Run the script to remove the specified Primary Keys from your Staging Database.

Check the Log File and Subset Report at this stage, to check that the Actions have performed correctly.

Next, check your Database to make sure the Primary Keys constraints have been removed. You can then update your Control Spreadsheet and Add Primary Keys if you want.