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 / gaurav , ashish ,preeti , main

Primary key is used to identify a row in a table 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

Is This Answer Correct ?    57 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to import one table back from a dump file?

969


Why packages are used in oracle?

1000


Can we insert data in view oracle?

958


What do you mean by a tablespace?

980


What happens to indexes if you drop a table?

1108


What is the difference between view and materialized view in Oracle?

1091


How to use null as conditions in oracle?

1001


Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2063


Is java required for oracle client?

923


What is enter substitution variable in oracle?

982


How to assign values to data fields in record variables?

973


What are the differences between date and timestamp in oracle?

973


What is the difference between pre-select and pre-query?

1123


How translate command is different from replace?

1005


I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2396