Please tell me a query to find the Primary key,Foreign
key,primary Index,PPI for the Database?
Answer Posted / innocent
--Find indixes.
Select TableName,ColumnName,IndexType,UniqueFlag,IndexName
From DBC.Indices
Where tableName='mytable_name'
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
if collect stats but it show low confidence why?
What are the functions involved in shared information architecture?
What are the components used in smp and massively parallel processing (mpp) machines?
Highlight the points of differences between the database and user in Teradata.
What is spool space?
Comment whether bottleneck is an error or not.
Explain parsing engine in teradata?
How do you see a ddl for an existing table?
Differentiate primary key and partition key?
How do you do backup and recovery in teradata?
What are teradata utilities?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
If RDBMS is halted what will you do ?
What is meant by a Virtual Disk?
What do you mean by teradata sql assistant?