Please tell me a query to find the Primary key,Foreign
key,primary Index,PPI for the Database?
Answer Posted / yuvaevergreen
Adding to the above,DBC.Indexes can be used to find whether
the index is PPI or join or hash or primary key.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
In Teradata, how do we Generate Sequence?
What are default access rights in teradata?
What are the primary characteristics of the Teradata.
How do you set the session mode parameters in bteq?
What are the different methods ot loading a dimension table? A fact table etc?
Explain teradata vs. Redshift?
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
Why is the case expression used in teradata?
What are the joins in teradata?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
What are the various indexes in teradata?
What type of indexing mechanism do we need to use for a typical data warehouse?
what are the uses of fact table and dimension table in banking project?
Explain amp in teradata?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong