constraintText in dbc.indexConstraints with constraintType = ‘Q’ (PPI)
SEL CAST ((TRIM( SUBSTRING(constrainttext FROM (INDEX(constrainttext,'''')+1) FOR 10))) AS DATE)
WHERE databasename = database
AND tablename = table
AND constrainttype = 'Q'
gives you the start date of the partition with or withoud data.
Have also similar requirement . Vanitha . Could you please share to me what have you done .
Already I did purge the OLD data but got stuck up in "Drop the Partion" and Add new partion.