Deleting a Partition

Drop a user or proxy table partition.

  • You must set the select into/bulkcopy/pllsort database option to true before you can delete a partition.

See the Transact-SQL Users Guide for information about partitions.

  1. Expand ASE Servers > Schema Objects > Tables, then choose one of:
    • User Tables
    • Proxy Tables
  2. Click the Name field of the table, then click the drop-down arrow and select Properties.
  3. In the left pane, click Partitions.
  4. Click the drop-down arrow and select New, or choose to an existing partition from the right pane.
  5. Click the Name field of the partition, then click the drop-down arrow and select Delete.
    You see the Confirm Delete dialog.
  6. Click OK.