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 ?
metadatateradata
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 ?
Best Answer
dbc.PartitioningConstraintsV
contains info about all partitioned tables.SHOW TABLE mytable
returns theCREATE TABLE
statement for this particular table.