What is Foreign Key?
What is the main difference between primary key and Foreign
Key ?
How Foreign Key can be defined?
Is Foreign key is used to join two or more table?
Answer Posted / balaji ganesh doddi
Foreign key is establish the relationship between two
tables.
Primary key is used to uniqly identified by the data into a
table.
The major differences are
Primary key should not contain null values and redundant
value.
Foreign key can contain redundant value.
Foreign key is a primary key of reference table.
Foreign key is defined as= create table employee(empno int
not null,empname char(40)not null,dept char(20),foreign
key(dept)references department(deptno))
Yes Foreign key is used t join two or more tables.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to decrement dates by 1 in mysql?
How to update database permissions/privilages.
Does insert statement lock the table?
Can we store files in mysql?
What is difference between oracle and mysql?
What you can use regular expression for in mysql? Support your answer with an example?
Who developed mysql?
What do you understand by mysql terminal?
What are the column comparisons operators?
How to display top 10 rows in mysql?
Can we write procedure in mysql?
Is mysql a nosql database?
What is the use of mysql_close()?
Can mysql scale horizontally?
Where does mysql store data?