Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7892 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 functions of mysql?
What is different between sql and mysql?
How many columns is too many mysql?
How do I tune a mysql query?
Can you tell how many values can set the function of mysql to consider?
Explain the difference between primary key and candidate key in mysql?
What is unsigned in mysql?
How do you insert a table?
What is row locking in mysql?
How to drop an existing view in mysql?
Is mysql a programming language?
How do I show columns in mysql?
How to include comments in sql statements?
How can you see all indexes defined for a table?
How do I know if mysql is installed on windows?
