Archives of the TeradataForum
Message Posted: Thu, 15 May 2014 @ 10:47:23 GMT
| Subj: | | Re: How to Identify Partitioned Columns |
| |
| From: | | Dieter Noeth |
Anomy.Anom wrote:
| | I am trying to create a list of the columns which make up the PPI in a table. | |
| | I have tried DBC.Constraints but it looks like I would have to unpick the column names. | |
If you got luck you're on TD14:
SELECT * FROM dbc.ColumnsV WHERE PartitioningColumn = 'Y'
Before my StatsInfo view returns that info in PartitionColumn:
developer.teradata.com/blog/...
Dieter
| 
