Interested to Buy Any Domain ? << Click Here >> for more details...
what is primary key,unique key, foreign key? can u teach me
in simple language?
- 44 Answers
- 187880 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
Answer Posted / doraswamy
One table allows only one primary key but there is no
restriction for unique keys.
These two are same but one difference is unique key will
allow nulls.
Primary key create on a combination of mulitiple colums.
Foreign key is reference of another table primiary key. It
will not allow null values.
~Doraswamy
| Is This Answer Correct ? | 106 Yes | 43 No |
Post New Answer View All Answers
Which database is best to store images?
How to do performance tunning a database in DB2 V8.2 UDB in linux
What are the tools used for backup and ticketing?
During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
List various types of log-based recovery in DBMS.
Can you create a database in word?
A design problem was given in which I was supposed to make a design for the data base for a given problem.
How do I manually create a database?
What is odm database?
What is ole db provider for sql server?
Is redis in memory database?
how can you perform lookup range in lookup stage expalin in detail?
Is hive a database?
What is replicaset?
What do you mean by foreign key and primary key?
