Please tell me a query to find the Primary key,Foreign
key,primary Index,PPI for the Database?
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
In Teradata, what is the significance of UPSERT command?
What is the purpose of joins in teradata and what are the available join types?
What do you mean by ttu in teradata?
How do you do backup and recovery in teradata?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What is stored procedure in teradata?
How do you verify a complicated sql?
How is MLOAD Teradata Server restarted after execution?
What is teradata? What are some primary characteristics of teradata?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What can be achieved by using the teradata rdbms?
What are the steps involved in the process flow of the sql statement through channel attached system?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
if collect stats but it show low confidence why?
What are the different functions performed in development phase?