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
- 26889 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
any one answer me how they can analyzing the project using data ware housing?
Why are oltp database designs not generally a good idea for a data warehouse?
Difference between stored procedure and macro?
What do you mean by teradata intelliflex?
What is called partitioned primary index (ppi)?
What is the syntax for case when statement?
Where is teradata rdbms used?
What is the meaning of Caching in Teradata?
if collect stats but it show low confidence why?
Explain the new features of teradata?
What are the updated features of teradata?
How can you track login parameters of users in teradata?
Explain teradata architecture?
What is the maximum number of dml can be coded in a multiload script?
What are the various indexes in teradata?
