We can find the information of all the indexes in the system table "

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

Question Posted / bhanu prasad

Answer Posted / bhanu prasad

We can find the information of all the indexes in the
system table "dbc.indices"

Is This Answer Correct ?

19 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Explain and compare pros and cons of start schemas?

1000

Explain teradata architecture?

1045

During the Display time, how is the sequence generated by Teradata?

990

In general, how do you optimze any sql in teradata?

999

In Teradata, how do we Generate Sequence?

1000

What are the available primary index types?

1169

How to view every column and the columns contained in indexes in teradata?

998

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

951

Explain the new features of teradata?

1007

Why managing the data is important?

978

Explain fallback in teradata?

1004

how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

1683

How to find duplicates in a table?

1168

How can you track login parameters of users in teradata?

1144

What are teradata utilities?

1057