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
- 186496 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sathish
1)Primary key is unique key but foriegn key always refers
to
primary key.
2) Primary keys enforce entity integrity by uniquely
identifying entity instances. Foreign keys enforce.
3)Primary key is unique
primary key is not NULL and
foreign key is NULL
foreign key reference as Primary key in another table.
4) primary key is used to identify a row and it doesnot
allow
null values. It avoids duplication of rows.
whereas foreign key refers to a column or combination of
columns included in the defenition of referential integrity.
referential integrity by completing an association between
two entities.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is difference between clustered, non-clustered and unique index?
How default key is different from primary key?
Data structure used to implements a menu:
What is the best database?
What is the difference between specialization and generalization?
what is transaction state, buffer management, shadow paging
How many indexes can be created on a table?
What are the advantages of normalizing a database.
What is the difference between primary and candidate key?
What is difference between server and database?
What is lagging in DBMS ?
How many types of normalization? What is the use of it?
What is Object Oriented model?
What is replicaset?
where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it
