Lets just do this for greenplum for the time being

We already display Table Partition information in Oracle. See attached screenshot

Done - Greenplum only
   14.0  - SVN r33508/14.0.0-beta-81
   trunk - SVN r33509/15.0.0-dev-7

Greenplum supports partitions in a hierarchical structure which is displayed in ADS' schema browser as:
   - Table
      - Partitions
         - Subpartitions
            - Subpartitions
               - Subpartitions
                  - ...

The CREATE TABLE script below is described in the Greenplumn Database Administrator Guide 4.2, page 479. This script will create a 3-level partition hierarchy containing 594 partition tables. This fix uses this example script to verify its correctness. In ADS, you can use the information displayed in Partitions/Subpartitions nodes' detail view to verify the relationships among created partition tables. See GreenplumPartitions screenshot for details.

CREATE TABLE tableName (id int, year int, month int, day int, region text)
   DISTRIBUTED BY (id)
   PARTITION BY RANGE (year)
      SUBPARTITION BY RANGE (month)
      SUBPARTITION TEMPLATE (
         START (1) END (13) EVERY (1),
         DEFAULT SUBPARTITION other_months )
      SUBPARTITION BY LIST (region)
      SUBPARTITION TEMPLATE (
         SUBPARTITION usa VALUES ('usa'),
         SUBPARTITION europe VALUES ('europe'),
         SUBPARTITION asia VALUES ('asia'),
         DEFAULT SUBPARTITION other_regions)
   ( START (2002) END (2010) EVERY (1),
   DEFAULT PARTITION outlying_years);

Verified in 14.0.0-beta-82

Sample script for Subpartions which worked :

CREATE TABLE sales1 (id int, year int, month int, day int, region text)

DISTRIBUTED BY (id)

PARTITION BY RANGE (year)

SUBPARTITION BY RANGE (month)

SUBPARTITION TEMPLATE (

START (1) END (13) EVERY (1),

DEFAULT SUBPARTITION other_months )

SUBPARTITION BY LIST (region)

SUBPARTITION TEMPLATE (

SUBPARTITION usa VALUES ('usa'),

SUBPARTITION europe VALUES ('europe'),

SUBPARTITION asia VALUES ('asia'),

DEFAULT SUBPARTITION other_regions )

( START (2002) END (2010) EVERY (1),

DEFAULT PARTITION outlying_years );

GO