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
- 7714 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 is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba
How do I create a mysql database?
List the different types of normalization?
What is mysql_connect?
What is mysql cursor?
Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?
Explain the difference between mysql and mysql interfaces in php?
How to find the unique values if the value in the column is repeated?
How would you enter characters as hex numbers?
What is 'mysqladmin' in mysql?
Is mysql a database?
How to store binary data in mysql?
What is insert query in mysql?
What is meant by sharding?
How you will Show unique records.
