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
- 27102 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's the difference between timestamp (0) and timestamp (6)?
What are the uses of bynets in multi-node systems?
What are default access rights in teradata?
What are tpump utility limitations?
What interface is used to connect to windows based applications?
What is meant by a Channel Driver?
what are the uses of fact table and dimension table in banking project?
What happens in a conflict? How do you handle that?
What are the components used in smp and massively parallel processing (mpp) machines?
In BTEQ, how are the session-mode parameters being set?
How is MLOAD Teradata Server restarted after execution?
What do you mean by teradata sql assistant?
Describe primary index in teradata. And what are the available primary index types?
Describe the between keyword in teradata?
What is the primary index in teradata?
