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

What does an inner join do?

1248


What is data modelling in sql?

1075


What is procedure in pl sql?

1090


Can variables be used in sql statements?

1073


Is like operator in sql case sensitive?

1077


Can delete statement be rollbacked?

1032


How to know the last executed procedure?

1156


What is trigger types in sql?

1043


What is raid? How does it help storage of databases?

1133


What is pl/sql language case sensitive?

1181


What is java sql connection?

1120


How do we accept inputs from user during runtime?

1118


Which join is like an inner join?

1093


What is a trigger word?

1077


Explain the difference between 'between' & 'and' operators in sql

1046