what is primary key,unique key, foreign key? can u teach me
in simple language?
- 44 Answers
- 174148 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
What are different types of joins used in?
What are the various ways to execute a query in teradata?
Explain transaction manager?
Explain database partitioning.
Explain about ur projets on teradata???
hai if any one having any project sample table structure please froward to my mail id tauseefwst@yahoo.com
diff b/w inter process and in process
What is the use of graph database?
aht is the difference b/w network & hierarchial & relational dbms????
If the master device is full, how do I make the master database bigger?
What do you mean by cluster and non cluster index?
What does specialization in DBMS mean?
Display the employees whose salary is less than average salary.
What is redis good for?
can u combine pipeline parallelism and partition parallalism? how and whan?
