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 primary key & foreign key?

Answer Posted / mathiyarasan

Primary is unique one. Each table has only one primary key.
But not allow null values.

Foreign key is opposite of primary. It is reference of
primary key from another table. It allow Null value. Each
table can have more than one foreign key.

Foreign key is used to link one to another table.

Is This Answer Correct ?    22 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we write dml statement in function in oracle?

1082


Why do we use bulk collect in oracle?

1058


What is tns entry?

1152


what is port in oracle? how is it related to database application.

1949


Explain the use of show option in imp command.

1098


What is redo log?

1067


How to add a new column to an existing table in oracle?

1140


How can I combine multiple rows into a comma-delimited list in oracle?

1062


What is a table in oracle?

981


What is primefaces used for?

1049


Explain the types of exception?

1144


Explain database link?

1126


hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1999


What would you do with an in-doubt distributed transaction?

1980


What is the difference between primary key and unique key and foreign key in oracle?

982