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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

541


Why do you get spool space errors? How do trouble-shoot them?

587


i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

1763


What are the various indexes in teradata? How to use them? Why are they preferred?

589


What are the components used in smp and massively parallel processing (mpp) machines?

593






What does sleep function does in fast load?

616


How would you load a very large file in teradata in general? What utility would you use for it? Why?

589


Can you fastexport a field, which is primary key by putting equality on that key?

706


Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

1955


Highlight the points of differences between the database and user in Teradata.

583


Explain teradata architecture?

630


How to run a query in teradata?

578


How do you define Teradata?

603


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

568


Explain the parallel data extension in teradata?

652