Please tell me a query to find the Primary key,Foreign
key,primary Index,PPI for the Database?
Answer Posted / bhanu prasad
We can find the information of all the indexes in the
system table "dbc.indices"
Is This Answer Correct ? | 19 Yes | 4 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?
Can you fastexport a field, which is primary key by putting equality on that key?
Highlight the points of differences between the database and user in Teradata.
What is the use of fallback?
Why do you get spool space errors? How do trouble-shoot them?
Is multi insert ansi standard?
What are the primary characteristics of the Teradata.
how can we analyze the locks ?
What is TPD?
What are the components used in smp and massively parallel processing (mpp) machines?
How to find duplicates in a table?
What is the purpose of joins in teradata and what are the available join types?
What are the various indexes in teradata?
How do you verify a complicated sql?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?