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


Please Help Members By Posting Answers For Below Questions

Explain the term 'row' related to relational database management system?

735


In Teradata, how do we Generate Sequence?

810


Highlight a few of the important components of Teradata?

798


why use references rather than pointers in the public api, particularly for arguments which are modified?

775


Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

1928


How do you do backup and recovery in teradata?

805


What is the primary index in teradata?

820


What are the different softwares used with their functions in teradata?

790


When tpump is used instead of multiload?

860


Explain Teradata performance tuning and optimization?

932


What are some primary characteristics of teradata?

756


Explain the term 'primary key' related to relational database management system?

831


how do you manage the production space. what are the proactive methods you can take ?

1677


A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?

915


What are the different functions included in the server software?

815