Archives of the TeradataForum

Message Posted: Thu, 24 Jan 2008 @ 20:24:27 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi all,

Are there tables / views in dbc that tells at least that a column is used in a partition (like a flag or something)?

The closest I could find out was this but will require some manipulation for ConstraintType = 'Q'

     select * from dbc.indexconstraints;

Thanks,

Tej

	<Prev	Next>		<<First	<Prev	Next>	Last>>