sp_iqtable Procedure

Syntax 1

sp_iqtable ( [ table_name ],[table_owner ],[table_type ] )

table_type:
    TEMP
   | VIEW
   | ALL
   | any_other_value

Syntax 2

sp_iqtable [table_name='tablename'],
[table_owner='tableowner' ],[table_type='tabletype' ]

Parameters

table_type –
- TEMP – Global temporary tables
- VIEW – Views
- ALL – IQ tables, global temporary tables, and views
- any_other_value – IQ tables

Privileges

You must have EXECUTE privilege on the system procedure.

Remarks

For Syntax 1, if you do not specify either of the first two parameters, but specify the next parameter in the sequence, you must substitute NULL for the omitted parameters. For example, sp_iqtable NULL,NULL,TEMP and sp_iqtable NULL,dbo,SYSTEM.

Note: The table_type values ALL and VIEW must be enclosed in single quotes in Syntax1.

For Syntax 2, the parameters can be specified in any order. Enclose them in single quotes.

Specifying one parameter returns only the tables that match that parameter. Specifying more than one parameter filters the results by all of the parameters specified. Specifying no parameters returns all SAP Sybase IQ tables in the database. There is no method for returning the names of local temporary tables.

Column Name	Description
table_name	The name of the table.
table_type	BASE – a base table. MAT VIEW – a materialized view. (SA tables only) GBL TEMP – a global temporary table. PARTITION – a table partition (this table is for internal use only and cannot be used by SAP Sybase IQ users). VIEW – a view.
table_owner	The owner of the table
server_type	IQ – an object created in the IQ store. SA – an object created in the SA store. All views are created in the SA store.
location	TEMP – IQ temporary store. MAIN – IQ store. SYSTEM – catalog store.
dbspace_id	Number that identifies the dbspace.
isPartitioned	'Y' if the column belongs to a partitioned table and has one or more partitions whose dbspace is different from the table partition’s dbspace, 'N' if the column’s table is not partitioned or each partition of the column resides in the same dbspace as the table partition.
remarks	User comments added with the COMMENT statement.
table_constraints	Constraints against the table.
PartitionType	If partitioned, indicates the type of partition. Hash-Range Range Hash None
isRLV	Indicates if the table is RLV-enabled.