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

How to use "for" statements in oracle?

1072


What are the oracle built-in data types?

1061


What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4519


I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2136


Please explain compound trigger in oracle?

1055


What happens if recursive calls get out of control?

1077


What is snapshot is too old? Give and example for better understand.

1601


 How to use an oracle sequence generator in a mapping?

1072


What is an oracle user account?

986


How to convert times to characters in oracle?

1025


How to login to the server without an instance?

1160


How to convert characters to numbers in oracle?

1063


What is a view and how is it different from a table?

1042


What do you mean by merge in oracle and how can you merge two tables?

948


how may join possible between (requisition with purchase order)

2243