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.
- 2 Answers
- 7634 Views
- I also Faced
- E-Mail Answers
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 is difference between user and database in teradata?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What is a node in teradata?
Highlight the differences between Primary Key and Primary Index.
How do you determine the number of sessions?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
How is the teradata different from oracle?
Can we collect statistics on multiple columns?
What is the function of parser component in teradata?
What is the difference between fastload and multiload?
Explain teradata architecture?
Explain the new features of teradata?
What is meant by Teradata Gateway?
What are the different table types supported by teradata?
