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 / 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
What is a data directory?
What is pragma autonomous_transaction?
How triggers can be used in mysql?
What is pdo in mysql?
What are the differences between a primary key and foreign key?
How do we delete a row in a table?
How to check if value already exists in mysql database in php?
What is mysqladmin flush hosts?
Differentiate CHAR_LENGTH and LENGTH?
how to Return total number of rows.
What is datadir?
Why we use mysqli instead of mysql?
What is max_used_connections in mysql?
How to get the current date in mysql?
What are Heap tables?