case when ix.is_unique_constraint = 1 then ' UNIQUE ' else '' END ,case when ix.is_primary_key = 1 then ' PRIMARY KEY ' else '' END , ix.type_desc, case when ix.is_padded=1 then 'PAD_INDEX = ON, ' ...
partition p0_gpi_table1 VALUES less than (10000), partition p1_gpi_table1 VALUES less than (20000), partition p2_gpi_table1 VALUES less than (30000), partition p3_gpi_table1 VALUES less than (maxvalue ...