what is referential constraints?how do you implement RI in
teradata?
- 2 Answers
- 6257 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 are the various indexes in teradata? How to use them?
Write a program to show the parser component used in teradata?
What is meant by a Highest Cost Plan?
How do you set the session mode parameters in bteq?
What are different table types used in teradata?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
Can you fastexport a field, which is primary key by putting equality on that key?
Highlight a few of the advantages that ETL tools have over Teradata.
any one answer me how they can analyzing the project using data ware housing?
Explain BYNET.
What are the various indexes in teradata? Why are they preferred?
In Teradata, what is the significance of UPSERT command?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What is the difference between global temporary tables and volatile temporary tables?
Why is the case expression used in teradata?
