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
- 8755 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
How many types of joins are there in teradata?
What are the newly developed features of Teradata?
How to run a query in teradata?
Explain the most common data types used in teradata?
What are the functions of a Parser?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What is teradata?
Explain and compare pros and cons of start schemas?
How do you create tables? Exact syntax, and create profiles, users in teradata?
Syntax for case when statement?
Explain teradata architecture in detail with a diagram.
Explain amp in teradata?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What is primary index and secondary index?
What are types of partition primary index (ppi) in teradata?
