IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN
ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CONSTRAINS.IF YES
HOW?PLZ GIVE ME A EXAMPLE.
Answers were Sorted based on User's Feedback
Answer / oceanblue
Yes, you can have a column for Primary key and have another
column which will have no duplicates or null.
A Salary Table will have employee ID as primary key. The
table also contains TAX-ID which can not be null or duplicate.
|Is This Answer Correct ?||7 Yes||0 No|
Answer / rajiv senapati
|Is This Answer Correct ?||2 Yes||0 No|
Can we Suggest as how is the process to get a job in teradata in current market??Is it easier???
How to copy teradata scripts from ur remote desktop to server machine?
Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?
What is the process to restart the multiload if it fails?
what is single value and Multivalue ?
teradata support to automatically increase the character length or not?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. firstname.lastname@example.org
Does SDLC changes when you use Teradata instead of Oracle?
what is the query for retrieve the unique values(not display the duplicates values) from single table?
what is identity column in TD?
What are the differences between TerdataV2R5 and V12 Versions please??
IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.