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
- 7645 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 datatype for password in mysql?
What is key in mysql?
Where’s database data actually stored? Is there a way to see the files which are stored?
What is the insert?
What is insert query in mysql?
How do I clear the command in mysql?
Can I use mysql for free?
How to include character strings in sql statements?
What is the use of mysqli_fetch_assoc?
What is striped backup
How can I connect mysql database?
What are the types of index?
Does uninstalling mysql delete database?
Write a query to select all teams that won either 1, 3, 5 or 7 games.
Who developed mysql?
