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
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Comment whether bottleneck is an error or not.
What are the commands to make a new table, change a table and remove a table in teradata?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
What is primary index and secondary index?
Difference between multiload and tpump?
What are the updated features of teradata?
Why managing the data is important?
Explain the term 'primary key' related to relational database management system?
What tools would you use for that?
What are the main components of teradata system?
What is the use of virtual processor connectivity in teradata?
What are the functions performed by bynet?
What are the functions of a teradata dba?