--Find indixes. Select TableName,ColumnName,IndexType,UniqueFlag,IndexName

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

Question Posted / innocent

Answer Posted / innocent

--Find indixes.
Select TableName,ColumnName,IndexType,UniqueFlag,IndexName
From DBC.Indices
Where tableName='mytable_name'

Is This Answer Correct ?

6 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Highlight the limitations of TPUMP Utility.

1068

Explain vproc in teradata?

951

How can we check the version of Teradata that we are using currently?

1032

What is TPD?

1326

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

1024

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1123

What is partitioned primary index (ppi)?

1018

What is logical data model?

1166

Explain the advantages of partitioned primary index in a query?

990

What is database exceptions in teradata?

914

What are aggregate tables? How do you design them using teradata?

1112

What is inner join and outer join?

1061

What are the updated features of teradata?

1008

How is MLOAD Client System restarted after execution?

1081

any one answer me how they can analyzing the project using data ware housing?

2429