what is referential constraints?how do you implement RI in
teradata?
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 functions of a teradata dba?
What does Amp contain and what are all the operations that it performs?
Can we collect statistics on multiple columns?
Explain the term 'columns' related to relational database management system?
In Teradata, how do we Generate Sequence?
During the Display time, how is the sequence generated by Teradata?
Explain teradata architecture?
Is multi insert ansi standard?
How do you see a ddl for an existing table?
What is the purpose of joins in teradata and what are the available join types?
In Teradata, what is the significance of UPSERT command?
When tpump is used instead of multiload?
What type of indexing mechanism do we need to use for a typical data warehouse?
How many tables can you join in v2r5?
What are the uses of client software involved in teradata?