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
- 8987 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 modules are there in telecome domain?how to explain the architecture?
Difference between stored procedure and macro?
What are the various etl tools in the market?
Explain the term 'columns' related to relational database management system?
Which is more efficient group by or distinct to find duplicates?
What is the use of having index on table?
What happens in a conflict? How do you handle that?
What are the newly developed features of Teradata?
What are some primary characteristics of teradata?
What are the different functions performed in development phase?
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?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
In Teradata, what is the significance of UPSERT command?
What is meant by a Clique?
What are the functions involved in shared information architecture?
