Date partitioned tables

Database
Enthusiast

Date partitioned tables

Hi All,

Can any one tell me how to pull all the date partitioned tables from the system.

Regards,

Praveen

2 REPLIES
Enthusiast

Re: Date partitioned tables

Hi Praveen,

There is a DBC view available named dbc.indexconstraints. You can use this view to get all the partitioned table names. The partitioned tables have a constrainttype of 'Q'. There is also an attribute constrainttext which contains original partition expression. You can use like operator to find the date partitioned tables.

for example

SELECT * FROM dbc.indexconstraints
WHERE Constrainttype = 'Q' AND ConstraintText like '%%';
Khurram
Enthusiast

Re: Date partitioned tables

Thanks Khurram :)