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 the purpose of joins in teradata?

1160

Explain parsing engine in teradata?

1082

Explain the term 'columns' related to relational database management system?

1060

What is meant by a dispatcher?

1008

What are differences between teradata and ansi session modes in teradata?

1167

What is the difference between teradata and basic rdbms?

1009

What type of indexing mechanism do we need to use for a typical data warehouse?

1155

What are the various etl tools in the market?

1066

If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

2155

How to Extract data from multiple legacy systems?

1108

Syntax for case when statement?

1054

What does Amp contain and what are all the operations that it performs?

995

What are the main components of teradata system?

1121

List out teradata data types?

1002

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

1769