Please tell me a query to find the Primary key,Foreign
key,primary Index,PPI for the Database?
Answer Posted / innocent
Hi Parsad,
I hope by running below query you'll get many part of your
answer.
_----------------------------------------------------------_
Select DatabaseName, TableName ,columnName,
Case When IndexType='K' Then 'Primary Key'
When IndexType='S' Then 'Secondary Index'
When IndexType='P' Then 'Primary Index'
When IndexType='Q' Then 'PPIndex'
When IndexType='J' Then 'Join Index'
End as implimented_Index
From DBC.Indices
Where TableName in
( Select distinct TableName
From DBC.Tablesize
Where DatabaseName <>'DBC'
And
CurrentPerm>0
)
Order by 1,2,3
_
Innocent
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is meant by a Parsing Engine?
What are the available primary index types?
why use references rather than pointers in the public api, particularly for arguments which are modified?
What is a three-tier data warehouse?
What is meant by a dispatcher?
What do you mean by tpt in teradata?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Explain the advantages of partitioned primary index in a query?
what are the day to day activities of teradata DBA ?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What are the components provided on node?
What are the joins in teradata and how many types of joins are there in 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 does sleep function does in fast load?
Explain the teradata primary index mechanics in detail with a diagram.