Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is the difference between the Primary and Foreign key?

Answer Posted / dhirendra

Primary Key: This is a constraint which is always unique &
not null.

Foreign Key: This is a constraint which is just opposite to
Primary key. It can be not Null & can accept duplicate value
as well. Foreign key points to same table's primary key or
another table's primary key to make a relationship.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why left join is used in sql?

959


Which normal form is best?

937


What is oracle sql called?

902


What are the parts of a sql statement?

1072


How global cursor can be declare with dynamic trigger ?

2189


What are the advantages of indexing?

967


What are all the different types of indexes?

1126


How do I send sql query results to excel?

1048


What are inner and outer joins examples of both?

940


What is sql in oracle?

1044


Does oracle use sql?

909


Can we use pl sql in mysql?

997


How do I sort a table in sql?

1020


What is the difference between nvl function, ifnull function, and isnull function?

1086


What is the sql*loader? : aql loader

1039