Reclaiming space using bcp

To reclaim space with bcp:

  1. Copy the table out to a file using bcp.

  2. Truncate the table with the truncate table command.

  3. Copy the table back in again with bcp.

See “Steps for partitioning tables” for procedures for working with partitioned tables.

For more information on bcp, see the Utility Guide manual for your platform.