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

What are the enhanced features in teradata v2r5 and v2r6?

695


What are the various indexes in teradata? Why are they preferred?

567


Explain the types of join supports by teradata?

590


Explain the most common data types used in teradata?

595


What is stored procedure in teradata?

594






Write a program to show the parser component used in teradata?

554


What are normalization, first normal form, second normal form and third normal form?

636


Explain vproc in teradata?

566


What is spool space?

609


Steps to create a data model?

666


How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1287


Explain and compare pros and cons of snow flake schemas?

613


What are the uses of bynets in multi-node systems?

590


What exactly do you know about catching in teradata?

645


Give a justifiable reason why Multi-load supports NUSI instead of USI.

684