Interested to Buy Any Domain ? << Click Here >> for more details...
what is primary key and foreign key when and where have to use
- 5 Answers
- 7537 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prashant
primary key has a unique & it is only one in a
databasewhile fkey is not unique. it is based on primary key
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ramprasad.s
HI
Primary key = (Not Null + Unique).
Foreign key = (For Referential table access).
Bye
sun_ramprasad@yahoo.com
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / chandrika
primary key has unique value, it dostnt contain null values
and duplicate values.
foregin key is primary key of another table
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / raveendran
Primary key is unique across entire table.In primary key
not null constraint is activated.Only one primary key in
one table.
foreign key points to primary key of another table
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / csprusty
To establish a relationship between 2 tables.
pk=(unique+not null)
fk=unique
| Is This Answer Correct ? | 1 Yes | 2 No |
How to lock and unlock a user account in oracle?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
What is oracle open database communication (odbc)?
definition of cluster and non-clustered index?
How to create a table index in oracle?
How to enter a new row into a table interactively?
How to check the server version in oracle?
What is the difference between implicit index and explicit index?
what is view?
if i am using dml statement in function. then i am writing select statement what was the output
How to rename an existing table?
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
Oracle General 
