When a partitioned tables is created, IQ creates internally as many part_xxx tables as the number of partitions. (xxx being a number)
Those part_xxx tables are not real tables and cannot be queried.
End users shouldn't even know about their existence.
However, with Jconnect DatabaseMetadata.getTables method, the part_xxx tables are returned as LOCAL TEMPORARY tables.
- SAP IQ 16.0
- SAP IQ 16.1
JDBC; metaData.getTables; DatabaseMetadata; getTables; , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.