Identify Partition Column(s)

Database
Enthusiast

Identify Partition Column(s)

Hello,

In Teradata 14 , is there any way to identify the partition column(s) , except to check indexconstraints the constrainttext?

I want to create a script in order to get all the info about PI, system partition column , partitioned column(s) and left join to statsV in order to see if i have at least the initial stats.

Thank you very much.

2 REPLIES
Junior Contributor

Re: Identify Partition Column(s)

DBC.ColumnsV.PartitioningColumn = 'Y' :-)

Enthusiast

Re: Identify Partition Column(s)

Thanks,

Just found your reply  on http://teradataforum.com/teradata/20140515_104723.htm