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
- 27137 Views
- I also Faced
- E-Mail Answers
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
Why teradata is used?
Did you write stored procedures in teradata?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
How many codd's rules are satisfied by teradata database?
What is the purpose of indexes?
How would you load a very large file in teradata in general?
Explain the meaning of Amp?
What is meant by a Highest Cost Plan?
What do high confidence, low confidence and no confidence mean in explain plan?
What are the uses of bynets in multi-node systems?
What are the available primary index types?
What are the different methods ot loading a dimension table? A fact table etc?
What is node? How many nodes and amps used in your previous project?
How to load specific no.of records using bteq, or fastload,or multiload
