PPI Columns

Database
Enthusiast

PPI Columns

Hello,

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.

Regards

Tags (1)
1 REPLY
Junior Contributor

Re: PPI Columns

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:

SELECT *

FROM StatsInfo

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

Dieter