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
- 8995 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 are the functions involved in shared information architecture?
What is primary index and secondary index?
What is smp and mpp platforms?
Can you fastexport a field, which is primary key by putting equality on that key?
In general, how do you optimze any sql in teradata?
How to view every column and the columns contained in indexes in teradata?
What are the various etl tools in the market?
What are tpump utility limitations?
What is the purpose of indexes?
What is meant by a Virtual Disk?
How many codd's rules are satisfied by teradata database?
What are the frequently used data types in teradata?
What is meant by a dispatcher?
Explain Teradata performance tuning and optimization?
What is a clique?
