SAP Knowledge Base Article - Preview

2228276 - How to view partitioned tables, types and keys using SQL queries - SAP IQ

Symptom

How can I gather the following information from an SAP IQ database using SQL rather than a GUI tool?

  1. List of Partitiooned tables
  2. Related partition types
  3. Related Partition Keys
  4. Related Partition names


Read more...

Product

SAP IQ 16.0

Keywords

SAP IQ; Partition; partitioned ; Key; Key column; Range; Hash; sp_iqtable; SYSPARTITIONSCHEME; SYSPARTITIONKEY; SYSPARTITION ; SYSPARTOITIONS ; dbspace , KBA , BC-SYB-IQ , Sybase IQ , How To

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.