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 ?    12 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define sql delete statement.

1016


How do you write a subquery?

1031


What is compilation error in pl sql?

983


What are hotfixes and patches?

949


Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1162


Show the two pl/sql cursor exceptions.

1201


Can a procedure in a package be overloaded?

1045


Can delete statement be rollbacked?

989


what is data control language? : Sql dba

1030


What is clustered index in sql?

1054


What is the use of pl/sql table?

1068


What are the two types of cursors in pl sql?

1082


How many types of triggers exist in pl/sql?

1075


Can a varchar be a primary key?

1009


What is trigger with example?

1104