How do I get a list of all the partitioned tables and partitioning details in my Teradata? How do I get a list of all the partitioned tables in teradata? 

and

How do I get a partitioning columns and details for a table  in teradata ?
dbc.PartitioningConstraintsV contains info about all partitioned tables.

SHOW TABLE mytable returns the CREATE TABLE statement for this particular table.