Interested to Buy Any Domain ? << Click Here >> for more details...
what is referential constraints?how do you implement RI in
teradata?
- 2 Answers
- 7143 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 bteq script in teradata?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
What are teradata utilities?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
Highlight all the modes that are present under Confidence Level.
Explain amp in teradata?
What is a level of granularity of a fact table?
How can bottlenecks be identified?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
List the logical and conditional operators that are used with teradata along with their meanings?
What are the functions performed by bynet?
what is sysdba and sysdbc ? which has high priority ?
What do you mean by parsing?
What is the difference between fastload and multiload?
What is the purpose of joins in teradata?
