Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8754 Views
- I also Faced
- E-Mail Answers
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.
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 |
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
In general, how do you optimze any sql in teradata?
What is bteq utility in teradata?
What are the multiload utility limitations?
If RDBMS is halted what will you do ?
Highlight the advantages of PPI(Partition Primary Index).
What are the different design perspectives used in teradata?
write lock is compatiable with which type of lock?
What are the primary characteristics of the Teradata.
What is the opening step in basic teradata query script?
List out some of the primary characteristics of teradata.
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Teradata 
