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 required. View any property page of a base table owned by any user – None required except Data page, which requires one of: DBA authority. SELECT permission on the table. You own the table. Modify any property on the General page requires one of: DBA authority. ALTER permission on the table. You own the table. Modify any property on the Miscellaneous page requires one of: SELECT ANY TABLE system privilege. SELECT permission on the table. You own the table. For privileges required 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 required. View any property page of a base table owned by any user – None required except Data page, which requires one of: SELECT ANY TABLE system privilege. SELECT permission on the table. You own the table. Modify the table name on the General page – Requires one of: ALTER ANY TABLE system privilege. ALTER ANY OBJECT system privilege. You own the table. Use the Calculate button on the Miscellaneous page – Requires 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 – Requires 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 – Requires 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 required 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 required.

View any property page of a base table owned by any user – None required except Data page, which requires one of:

DBA authority.
SELECT permission on the table.
You own the table.

Modify any property on the General page requires one of:

DBA authority.
ALTER permission on the table.
You own the table.

Modify any property on the Miscellaneous page requires one of:

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

For privileges required to modify other table properties, see:

SAP Sybase IQ 16.0

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

View any property page of a base table owned by any user – None required except Data page, which requires one of:

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

Modify the table name on the General page – Requires one of:

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

Use the Calculate button on the Miscellaneous page – Requires 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 – Requires 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 – Requires 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 required 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 Administration Console, expand IQ Servers > Schema Objects > Tables.
Select Tables.
In the right pane, select a table, click the drop-down arrow that appears next to the table name and select Properties.

View or modify table properties.

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.

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.)

Click OK.