Export tables

I use the Export Tables functionality to generate a script to move rows of setup information from one table into our test environment. I generally add a where clause to restrict the rows extracted. I had expected the delete records option to use the where clause as its criteria for deletion. So if I extract just a portion of the table and leave the delete records option checked, the whole table is deleted and just the handful of records (identified by the where clause) are re-inserted.

My question: Can either the delete records not be checked by default or could the delete make use of the where clause in some way?

Tom
 
Back
Top