Viewing or Modifying Base Table Properties

Display or change the properties of the selected IQ store (main store) or IQ system store (catalog store) base table.

Prerequisites

Note: The system privileges and permissions required vary by task. Unless otherwise indicated, the following system privileges and permissions apply.

Database Version	Table Privileges
SAP Sybase IQ 15.3 and 15.4	View any property page of a base table owned by self – none. View any property page of a base table owned by any user – none needed except for the Data page, for which you must have one of: DBA authority SELECT permission on the table You own the table Modify any property on the General page – you must have one of: DBA authority ALTER permission on the table You own the table Modify any property on the Miscellaneous page – you must have one of: SELECT ANY TABLE system privilege SELECT permission on the table You own the table For privileges needed to modify other table properties, see: Table Column Privilege Summary Table Permissions Privilege Summary Table Constraints Privilege Summary Table Index Privilege Summary Table Trigger Privilege Summary Table Partition Privilege Summary
SAP Sybase IQ 16.0	View any property page of a base table owned by self – none. View any property page of a base table owned by any user – none needed except for the Data page, for which you must have one of: SELECT ANY TABLE system privilege SELECT permission on the table You own the table Modify the table name on the General page – you must have one of: ALTER ANY TABLE system privilege ALTER ANY OBJECT system privilege You own the table Use the Calculate button on the Miscellaneous page – you must have one of: SELECT ANY TABLE system privilege SELECT permission on the table You own the table Modify any other property on the Miscellaneous page for an IQ catalog (system) store table – you must have one of: ALTER ANY TABLE system privilege ALTER ANY OBJECT system privilege ALTER permission on the table You own the table Modify a comment on the General page – you must have one of: CREATE ANY TABLE system privilege ALTER ANY TABLE system privilege CREATE ANY OBJECT system privilege ALTER ANY OBJECT system privilege COMMENT ANY OBJECT system privilege You own the table For privileges needed to modify other table properties, see: Table Column Privilege Summary Table Permissions Privilege Summary Table Constraints Privilege Summary Table Index Privilege Summary Table Trigger Privilege Summary Table Partition Privilege Summary

Database Version

Table Privileges

SAP Sybase IQ 15.3 and 15.4

View any property page of a base table owned by self – none.

View any property page of a base table owned by any user – none needed except for the Data page, for which you must have one of:

DBA authority
SELECT permission on the table
You own the table

Modify any property on the General page – you must have one of:

DBA authority
ALTER permission on the table
You own the table

Modify any property on the Miscellaneous page – you must have one of:

SELECT ANY TABLE system privilege
SELECT permission on the table
You own the table

For privileges needed to modify other table properties, see:

SAP Sybase IQ 16.0

View any property page of a base table owned by self – none.

View any property page of a base table owned by any user – none needed except for the Data page, for which you must have one of:

SELECT ANY TABLE system privilege
SELECT permission on the table
You own the table

Modify the table name on the General page – you must have one of:

ALTER ANY TABLE system privilege
ALTER ANY OBJECT system privilege
You own the table

Use the Calculate button on the Miscellaneous page – you must have one of:

SELECT ANY TABLE system privilege
SELECT permission on the table
You own the table

Modify any other property on the Miscellaneous page for an IQ catalog (system) store table – you must have one of:

ALTER ANY TABLE system privilege
ALTER ANY OBJECT system privilege
ALTER permission on the table
You own the table

Modify a comment on the General page – you must have one of:

CREATE ANY TABLE system privilege
ALTER ANY TABLE system privilege
CREATE ANY OBJECT system privilege
ALTER ANY OBJECT system privilege
COMMENT ANY OBJECT system privilege
You own the table

For privileges needed to modify other table properties, see:

The SAP Sybase IQ resource is authenticated and running.
(Modifying properties only) In a multiplex configuration, the coordinator node is running.
(Enabling RLV in tables) The RLV store dbspace exists. (Row-level versioning can only be enabled in base tables in the IQ 16.0 main store for a simplex resource.)
(Partitioning tables) The table to be partitioned is empty.

Task

In the Perspective Resources view, select the resource, and select Resource > Administration Console.
In the left pane, expand IQ Servers > Schema Objects > Tables, and then select Tables.
Select a table from the right pane and either:
- Click the arrow to the right of the name and select Properties, or
- From the Administration Console menu bar, select Resource > Properties.
The Tables Properties view appears.

View or modify table properties.

When you are modifying properties, you need not click Apply before changing screens; however, doing so saves any changes.
If you do not have privileges to modify properties, SAP Control Center displays the properties view in read-only mode.

Area	Description
General	Name – Table identifier. Owner – (Read-only) Database user who owns the table. Type – (Read-only) Type of table - base table or global temporary table. Dbspace – (Read-only) The dbspace in which the table is located. Comment – Text description of the table. For example, describe the table's purpose in the system.
Columns	See Table Columns.
Permissions	(Base tables and global temporary tables only.) See Table Permissions.
Placement (Read-only)	Name – Name of the first table object. Dbspace – Dbspace occupied by the object. Size – Size of the object. % File – Percentage of the file used by this object. First Block – First block used by this object. Last Block – Last block used by this object.
Constraints	See Table Constraints.
Referencing Constraints	See Table Constraints.
Indexes	See Table Indexes.
Text Indexes	See Table Indexes.
Triggers	(System store tables only.) See Table Triggers.
Partitions	(Base tables only.) See Table Partitions.
Row-Level Versioning	Select the Enabled checkbox if you want the table to use row-level versioning to track row changes for read-write transactions on the table. Deselect the checkbox to disable row-level versioning. The RLV dbspace must exist before you can enable RLV on tables.
Dependent Views (Read-only)	Name – Name of the dependent view. Owner – Owner of the dependent view. View Type – Indicates if the view is a regular view or materialized view. Referenced Column – List of referenced table columns in the view. Dependency Type – Indicates if the dependency is direct or indirect.
Table Objects	Name – Name of the table object. Type – Type of table object. For example, "column". Partitions – Partition where this column's data is stored. Dbspace – Dbspace where the partition (storing the column data) resides. See Moving Table Objects to Another Dbspace.
Data (Read-only)	Note: For 15.3 and 15.4, requires SELECT permission on the table to view data. For 16.0, requires the SELECT ANY TABLE system privilege to view data. Displays the first 500 rows of data.
Miscellaneous Read-only)	Number of rows – Approximate number of rows in the table. To update this value, click Calculate. Calculate – (System store tables only.) Calculates the number of rows in the table. Number of Columns – (System store tables only.) Number of columns in the table. Time Created – (System store tables only.) Date and time the table was created. Time Updated – (System store tables only.)Date and time the table was last updated. Reserved space for each table page – (Catalog store tables only.) Table is replicating data – (Catalog store tables only.)

Do one of:
- Click OK to update any changes to the database and exit the properties view.
- Click Apply to update any changes to the database, but remain in the properties view.
- Click Cancel to cancel any changes not updated to the database and exit the properties view.