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?
- 4 Answers
- 6345 Views
- I also Faced
- E-Mail Answers
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
What are the ways in which you can retrieve data in the result set of mysql using php?
Explain timestamp?
What is the maximum size of mysql database?
Does mysql use t sql?
How many triggers are possible in mysql?
In how many ways we can retrieve data in the result set of mysql using php?
How would you get the current date in mysql?
In which format data is stored in mysql database?
How do I select a table in mysql?
What is a definer?
What does tinyint mean?
What are the technical specifications of mysql?
How can I create a database in mysql?
Why is it called mysql?
Which is best pdo or mysqli?
