Please tell me a query to find the Primary key,Foreign
key,primary Index,PPI for the Database?
- 5 Answers
- 25335 Views
- I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
What is inner join and outer join?
What is the difference between union and union all in teradata?
What is partitioned primary index (ppi)?
What is oltp?
Explain amp in teradata?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
List out some of the primary characteristics of teradata.
What is a clique?
What are some primary characteristics of teradata?
what is sysdba and sysdbc ? which has high priority ?
How is MLOAD Client System restarted after execution?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
if collect stats but it show low confidence why?
What are the different methods ot loading a dimension table? A fact table etc?
