I need to extract the tablenames and its corresponding column names(on which PPI has defined) where PPI is used in the table definition. Any inputs on this please.
When you're on TD14 it's easy:
SEL * FROM dbc.ColumnsV
WHERE PartitioningColumn = 'Y'
Otherwise you might use my StatsInfo view which provides this type of info:
WHERE PartitionColumn = 'Y' AND StatsType <> 'Part' AND ColumnCount = 1
You'll find it at http://developer.teradata.com/node/9598
I posted a new version today (when i tried this query i found a bug), please don't use any older version, otherwise there might be some partitioning columns missing