what is primary key and foreign key when and where have to use
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 |
can we pass two out parameters at a time in function?please answer to my question
HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT
5 Answers College School Exams Tests, DELL,
What are the differences between primary key and unique key?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
Tell me New Feature of Oracle 10g?
What is null value in oracle?
Explain oracle insert into command?
Explain the types of exception?
What is snapshot is too old? Give and example for better understand.
What are the different types of record groups in oracle? Explain each of them
What are the differences between char and nchar in oracle?
What is the Extension of Oracle Database? As extension of Access Database is .mdb