SAP Knowledge Base Article - Preview

3042864 - JConnect DatabaseMetadata.getTables returns part_xxx tables created by IQ internally for user partitioned tables - SAP IQ


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 


SAP IQ 16.0 ; SAP IQ 16.1


JDBC; metaData.getTables; DatabaseMetadata; getTables; , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

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