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.

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.

one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput like this way no name 20 siva 30 srinu 10 rao how it posible in only sql server query?not oracle?

3 Answers   IBM,

---

What is use of compress in terdata?Explain?

11 Answers  

---

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

0 Answers   HP,

---

Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD

6 Answers   Wipro,

---

Aborted in Phase 2 data acquistion completed in fastload?

2 Answers  

---

id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???

6 Answers   Cap Gemini,

---

what is the difference between primary index and secondary index?.

2 Answers   IBM,

---

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

0 Answers  

---

List out teradata data types?

0 Answers  

---

plz explain parlla distribution and subtable concept in teradata

3 Answers   TCS,

---

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

0 Answers  

---

Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.

13 Answers  

---