Archives of the TeradataForum
Message Posted: Sun, 11 May 2009 @ 00:51:04 GMT
<-- Anonymously Posted: Saturday, May 09, 2009 07:57 -->
Could someone suggest if there is a way to identify if a column is part of a Table Partitioning Expression from Dictionary Tables ? (I mean apart from scanning through ConstraintText of dbc.indexconstraints).
I intend to identify all columns that can be compressed. But while identifying all columns from dbc.columns, I will need to exclude the aforesaid columns as I won't be able to compress them...
Your suggestion is much appreciated....
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|