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
- 7879 Views
- I also Faced
- E-Mail Answers
Answer Posted / sunil kumar
Foreign key represents the relationship between two tables.
A foreign key in a table whose value is derived from the
primary key from some other table.The table in which foreign
key is defined is called a foreign table or detailed table.
The table that defines the primary key and is referenced by
the foreign table is called primary table or master table.
Difference between primary key and foreign key is that
primary key must contain a value,must not contain null
value,redundant value and foreign key can contain redundant
value.
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 ? | 13 Yes | 0 No |
Post New Answer View All Answers
Is mysql a server?
What storage engines are used in MySQL?
What is difference between inner vs self vs cross?
What do you understand by mysql terminal?
What is difference between mysql_connect and mysql_pconnect?
How can we get the number of rows affected by query?
How do I update a variable in mysql?
What is dbms in mysql?
What are string data types?
What is cast in mysql?
What is data directory in mysql?
Why should I use mysql?
How does mysql store binary data?
What is an index? How can an index be declared in mysql?
Can you tell how to find the number of rows in a resultset using php?
