Deleting a Partition

Delete one or more partitions from a table.

Prerequisites
Database Version Table Partition Privileges
SAP Sybase IQ 15.3 and 15.4 Table owned by self – None required.
Table owned by other users – Requires one of:
  • DBA authority.
  • ALTER permission on the table.
SAP Sybase IQ 16.0 Table owned by self – None required.
Table owned by other users – Requires one of:
  • ALTER ANY TABLE system privilege.
  • ALTER ANY OBJECT system privilege.
  • ALTER permission on the table.
Task
  1. In the Perspective Resources view, select the resource and select Resource > Administration Console.
  2. In the Administration Console, expand IQ Servers > Schema Objects > Tables.
  3. Select Tables, select the table in the right pane, click the drop-down arrow that appears beside the table name, and select Properties.
  4. Select Partitions.
  5. Select one or more partitions from the list and click Delete.
    The selected partitions are removed from the list but they are not yet deleted.
  6. Click Apply or OK to complete the deletion.
Parent topic: Table Partitions
Related tasks
Creating a Hash Partition
Creating a Range Partition
Creating a Hash-Range Partition
Unpartitioning a Table
Merging Partitions
Splitting Partitions
Moving a Partition
Managing Column Storage in a Table Partition
Viewing or Modifying Table Partition Properties
Authenticating a Login Account for a Managed Resource
Related reference
Table Partition Privilege Summary