Viewing or Modifying Table Partition Properties

View table partition details or change the table partition details and definition of an existing table partition.

Prerequisites

Database Version	Table Partition Privileges
SAP Sybase IQ 15.3 and 15.4	View any table partition property page – None required. Modify any table partition property pertaining to moving partition location or separate column storage for a partition – Requires one of: DBA authority. SPACE ADMIN authority CREATE permission on the dbspace to which the partition is being moved along with one of: ALTER permission on the underlying table. You own the table. Modify any other table partition property: 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	View any table partition property page – None required. Modify any table partition property pertaining to moving partition location or separate column storage for a partition – Requires one of: ALTER ANY TABLE system privilege. ALTER ANY OBJECT system privilege. MANAGE ANY DBSPACE system privilege. One of the following: CREATE ANY OBJECT system privilege. CREATE permission on the dbspace to which the partition is being moved. Along with one of: ALTER permission on the underlying table. You own the underlying table. Modify any other table partition property: 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.

Database Version

Table Partition Privileges

SAP Sybase IQ 15.3 and 15.4

View any table partition property page – None required.

Modify any table partition property pertaining to moving partition location or separate column storage for a partition – Requires one of:

DBA authority.
SPACE ADMIN authority
CREATE permission on the dbspace to which the partition is being moved along with one of:
- ALTER permission on the underlying table.
- You own the table.

Modify any other table partition property:

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

View any table partition property page – None required.

Modify any table partition property pertaining to moving partition location or separate column storage for a partition – Requires one of:

ALTER ANY TABLE system privilege.
ALTER ANY OBJECT system privilege.
MANAGE ANY DBSPACE system privilege.
One of the following:
- CREATE ANY OBJECT system privilege.
- CREATE permission on the dbspace to which the partition is being moved.
- Along with one of:
  - ALTER permission on the underlying table.
  - You own the underlying table.

Modify any other table partition property:

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.

The SAP Sybase IQ resource is authenticated and running.
In a multiplex configuration, the coordinator node is running.
You are licensed for the Very Large Database Management option (IQ_VLDBMGMT).

Task

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the Administration Console, expand IQ Servers > Schema Objects > Tables.
Select Tables, select the table in the right pane, click the drop-down arrow that appears beside the table name, and select Properties.
Select Partitions.
Select a partition from the list and click Edit.
View or modify table partition properties. The properties differ depending on the partition type.
- When modifying properties, clicking Apply before changing screens is not necessary, but will save any changes.
- If you do not have privileges to modify properties, Sybase Control Center displays the properties view in read-only mode.

Click OK.

The Properties view appears.

Hash Partition Properties

Area	Description
General	These properties cannot be edited. Name – Hash (Hash partitions are unnamed.). Type – Hash. Composite – N/A for a hash partition.. Partition key – Name of column(s) for the partition key.

Area

Description

General

These properties cannot be edited.

Name – Hash (Hash partitions are unnamed.).

Type – Hash.

Composite – N/A for a hash partition..

Partition key – Name of column(s) for the partition key.

Range Partition Properties

Area	Description
General	Name – Name of the range partition. Type – Range. Composite – N/A. Partition key – Name of the column for the partition key. Value – Value of the range partition. Dbspace – Dbspace that contains the range partition.
Columns	Column details for columns contained by the range partition. See Managing Column Storage in Table Partition Properties.

Area

Description

General

Name – Name of the range partition.

Type – Range.

Composite – N/A.

Partition key – Name of the column for the partition key.

Value – Value of the range partition.

Dbspace – Dbspace that contains the range partition.

Columns

Column details for columns contained by the range partition. See Managing Column Storage in Table Partition Properties.

Hash-Range Partition Properties

Area	Description
General	Name – Name of the hash-range partition. Type – Range. Composite – Hash-Range. Partition key – Name of the hash-range partition. Value – Value of the hash-range partition. Dbspace – Dbspace that contains the hash-range partition.
Column	Column details for columns contained by the hash- range partition. See Managing Column Storage in Table Partition Properties.

Area

Description

General

Name – Name of the hash-range partition.

Type – Range.

Composite – Hash-Range.

Partition key – Name of the hash-range partition.

Value – Value of the hash-range partition.

Dbspace – Dbspace that contains the hash-range partition.

Column

Column details for columns contained by the hash- range partition. See Managing Column Storage in Table Partition Properties.

Tip: You can modify changes in progress before they commit by clicking Properties and then making corrections.

Click Apply or OK to complete changes.