Interested to Buy Any Domain ? << Click Here >> for more details...
what is referential constraints?how do you implement RI in
teradata?
- 2 Answers
- 7273 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
Referential constraints define a relationship between two or
more attributes between two tables. RI can be implemented
between two tables using FOREIGN KEY option in create table.
FOREIGN KEY (b) REFERENCES WITH NO CHECK OPTION tb1(a));
CHECK or NO CHECK option can be used.
CHECK option - batch RI constraint.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the meaning of Caching in Teradata?
Explain the advantages of partitioned primary index in a query?
How can you track login parameters of users in teradata?
What are the joins in teradata?
What's the difference between timestamp (0) and timestamp (6)?
Highlight the advantages of PPI(Partition Primary Index).
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What is the purpose of joins in teradata and what are the available join types?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
List out some of the primary characteristics of teradata.
What are some commonly used bteq scripts?
If a Node is busy what are the steps you can take to avoid ?
Did you write stored procedures in teradata?
What is the multi-insert?
What is collect statistics?
