Unpartitioning a Table

Delete all 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. Click Unpartition.
    All partitions are removed from the list but the table is not yet unpartitioned.
  6. Click Apply or OK to complete unpartitioning.
Parent topic: Table Partitions
Related tasks
Creating a Hash Partition
Creating a Range Partition
Creating a Hash-Range Partition
Deleting a Partition
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