Please tell me a query to find the Primary key,Foreign
key,primary Index,PPI for the Database?
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 are the functions performed by bynet?
Describe the between keyword in teradata?
What type of indexing mechanism do we need to use for a typical data warehouse?
What interface is used to connect to windows based applications?
What are the various reporting tools in the market?
What is the function of parser component in teradata?
Did you write stored procedures in teradata?
What happens in a conflict? How do you handle that?
What are the functions involved in shared information architecture?
During the Display time, how is the sequence generated by Teradata?
how can we analyze the locks ?
Highlight a few of the important components of Teradata?
What are default access rights in teradata?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What is meant by a Parsing Engine?