Interested to Buy Any Domain ? << Click Here >> for more details...
what is referential constraints?how do you implement RI in
teradata?
- 2 Answers
- 7147 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 |
Why Multiload does not supports USI and supports NUSI?
What is upsert statement in teradata?
Difference between stored procedure and macro?
What is the difference between global temporary tables and volatile temporary tables?
Explain teradata utilities. What is multiload, fast load, tpump?
How can you track login parameters of users in teradata?
In Teradata, how do we Generate Sequence?
Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.
what is referential constraints?how do you implement RI in teradata?
Describe the between keyword in teradata?
What is the use of upsert command in teradata?
Why do you get spool space errors? How do trouble-shoot them?
Teradata 
