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.
Answer Posted / oceanblue
Yes, you can have a column for Primary key and have another
column which will have no duplicates or null.
e.g.
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 |
Post New Answer View All Answers
What are the advantages of teradata?
What are the multiload utility limitations?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What does Amp contain and what are all the operations that it performs?
How to find duplicates in a table?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What are the different functions included in the server software?
What is meant by a Virtual Disk?
What is the purpose of using case expression in teradata?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
How many tables can you join in v2r5?
What is smp and mpp platforms?
Did you write stored procedures in teradata?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
Can we collect statistics on multiple columns?