Adding to the above,DBC.Indexes can be used to find whether the index is

Please tell me a query to find the Primary key,Foreign
key,primary Index,PPI for the Database?

Question Posted / yuvaevergreen

Answer Posted / yuvaevergreen

Adding to the above,DBC.Indexes can be used to find whether
the index is PPI or join or hash or primary key.

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is teradata? Also, list out some of the primary characteristics of teradata.

771

What do high confidence, low confidence and no confidence mean in explain plan?

799

What do you mean by tpt in teradata?

769

What is a clique?

779

What is collect statistics?

768

What are the various etl tools in the market?

831

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3130

What is the primary index in teradata?

802

Explain the new features of teradata?

789

In Teradata, how do we Generate Sequence?

781

Describe primary index in teradata. And what are the available primary index types?

739

How you will check the version of teradata?

839

Why is the case expression used in teradata?

798

What are the string manipulation operators and functions associated with teradata?

835

Explain teradata utilities. What is multiload, fast load, tpump?

760