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
- 26886 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
What is teradata? Also, list out some of the primary characteristics of teradata.
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What is spool space?
Why are oltp database designs not generally a good idea for a data warehouse?
How you will check the version of teradata?
What can be achieved by using the teradata rdbms?
What's the difference between timestamp (0) and timestamp (6)?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
In the Primary Index, what is the score of AMPs that are actively involved?
Why is the case expression used in teradata?
Explain PDE.
What is smp and mpp platforms?
What are the primary characteristics of the Teradata.
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
How do you set the session mode parameters in bteq?
