Archives of the TeradataForum

Message Posted: Tue, 05 May 2009 @ 09:23:56 GMT

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

Hi David,

Thank you for the solution.

Is there any metadata repository in teradata which can give me the names of columns which are part of the Primary Index.

As per the below queires I have to hard code the columns which are part of PI .

But, I have to run the below query for each and every table in the database.

There are 3500 tables in my db.

Is there any way to do this dynamically?

Thank you,

Soujanya Kota

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