Viewing or Modifying Global Temporary Table Properties

Display or change the properties of the selected global temporary 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 global temporary table owned by self – none. View any property page of a global temporary table owned by any user – none needed except for the Data page, for which you need 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 permission on the table You own the table For permissions 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
SAP Sybase IQ 16.0	View any property page of a global temporary table owned by self – none. View any property page of a global temporary 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 – 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 – 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

Database Version

Table Privileges

SAP Sybase IQ 15.3 and 15.4

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

View any property page of a global temporary table owned by any user – none needed except for the Data page, for which you need 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 permission on the table
You own the table

For permissions needed to modify other table properties, see:

SAP Sybase IQ 16.0

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

View any property page of a global temporary 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 – 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 – 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.

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 Global Temporary 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 Global Temporary Table 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. Commit Action – (Read-only) Identifies if the table is Transactional or Non-transactional. Comment – Text description of the table. For example, describe the table's purpose in the system.
Columns	See Table Columns.
Permissions	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.
Triggers	See Table Triggers.
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 – Calculates the number of rows in the table. Number of Columns – Number of columns in the table. Time Created – Date and time the table was created. Time Updated – Date and time the table was last updated.

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.