Interested to Buy Any Domain ? << Click Here >> for more details...
what is referential constraints?how do you implement RI in
teradata?
- 2 Answers
- 7121 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / tdguy
Referential Integrity is based upon how Primary and Foreign
keys are defined. Because of this rule, a referenced column
must be a Primary Key or must be Unique and Not Null. Using
create or alter statement, FK can be created.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
What are types of partition primary index (ppi) in teradata?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
How to copy teradata scripts from ur remote desktop to server machine?
How do you load Multiple files to a table by using fastload scripts?
where we can use the delimiter in mload? pls let me know
what is referential constraints?how do you implement RI in teradata?
What type of indexing mechanism do we need to use for a typical data warehouse?
Can we collect statistics on multiple columns?
Can we load a Multi set table using MLOAD?
I want to write one query How to get Matched records and unmatched records in table?
Explain parsing engine in teradata?
What is differnce between Error code and Error Level in Bteq
Teradata 
