Interested to Buy Any Domain ? << Click Here >> for more details...
Please tell me a query to find the Primary key,Foreign
key,primary Index,PPI for the Database?
- 5 Answers
- 27126 Views
- I also Faced
- E-Mail Answers
Answer Posted / prasanna
Hi Innocent,
Appreciate for your answer.
But one small correction is that tablename and database name columns are present in DBC.indices itself where as you had went for a join condition with dbc.tablesize.
so without join condition we can take both tablename and database from dbc.indices table.
Thanks
Prasanna.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
If a Node is busy what are the steps you can take to avoid ?
How do you determine the number of sessions?
What is meant by a Parsing Engine?
Explain teradata vs. Redshift?
What are the advantages of teradata?
What is a node in teradata? Explain
Can we collect statistics on multiple columns?
Describe the between keyword in teradata?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What exactly do you know about catching in teradata?
What are the available join types in teradata?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
How does hashing happens in teradata?
What is called partitioned primary index (ppi)?
What are the updated features of teradata?
