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
- 8059 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
How to concatenate two character strings?
How do I enable mysqli extension?
What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?
How do I start mysql?
Explain the difference between mysql_fetch_array(), mysql_fetch_object()?
How to enter microseconds in sql statements?
What is information_schema in mysql?
Explain timestamp?
What is join in mysql? What are the different types of join?
How do I delete a table in mysql workbench?
What is a mysql model?
Can foreign key have duplicate values?
What is the usage of ENUMs in MySQL?
What is a delimiter in mysql?
What is longblob in mysql?
