--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

if collect stats but it show low confidence why?

1678

What are the functions involved in shared information architecture?

1070

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

1051

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

1103

What is spool space?

1149

Comment whether bottleneck is an error or not.

1145

Explain parsing engine in teradata?

1083

How do you see a ddl for an existing table?

1014

Differentiate primary key and partition key?

979

How do you do backup and recovery in teradata?

1011

What are teradata utilities?

1107

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

1772

If RDBMS is halted what will you do ?

2156

What is meant by a Virtual Disk?

1124

What do you mean by teradata sql assistant?

1049