How do I get a list of all the partitioned tables and partitioning details in my Teradata?
dbc.PartitioningConstraintsV contains info about all partitioned tables.

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