Retrieving Information about a Partitioned Table v10
Advanced Server provides five system catalog views that you can use to view information about the structure of partitioned tables.
Querying the Partitioning Views
You can query the following views to retrieve information about partitioned and subpartitioned tables:
The structure of each view is explained in Table Partitioning Views - Reference. If you are using the EDB-PSQL client, you can also discover the structure of a view by entering:
view_name specifies the name of the table partitioning view.
Querying a view can provide information about the structure of a partitioned or subpartitioned table. For example, the following code snippet displays the names of a subpartitioned table: