Run this Query if you want this thing
--Will give All tables having more than one Partition defined on same Columns only --
WHEN SINGLE_CHAR = '@' THEN 'RANGE_N'
WHEN SINGLE_CHAR = '$' THEN 'CASE_N'
END AS Partition_type
,COUNT(*) AS Level_of_MLPPI
SELECT DatabaseName,TableName,SUBSTR(SENT,POS,1) SINGLE_CHAR
(SELECT DISTINCT DatabaseName,TableName,
OREPLACE((oreplace(ConstraintText ,'CASE_N', '$')),'RANGE_N','@') AS sent FROM DBC.IndexConstraintsV
WHERE ( SUBSTRING(ConstraintText FROM 1 FOR 9) = 'CHECK (/*')
SELECT ROW_NUMBER() OVER (ORDER BY 1) Pos FROM sys_calendar.CALENDAR
WHERE Pos <= CHAR_LENGTH(SENT) AND SINGLE_CHAR IN ( '$' , '@')
GROUP BY 1 ,2,3 HAVING Level_of_MLPPI > 1
ORDER BY 1,2,3,4