What is the difference between the Primary and Foreign key?
Answer Posted / suresh babu
Primary key and foreign key both are constraints.
Primary key:We can create only one primary key for a
table,which never allows the repeated or duplicate values
and null values.The index will be created when defining a
primary key.And primary key is used to make a relation
between more than one tables.
Foreign key:It allows the duplicate and null values.if we
want to make a relation between two tables,the parent table
column must have primary column and child table column
called foreign key.
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is sql mysql pl sql oracle?
Can a foreign key be a duplicate?
What do you mean by rowid?
Is a view faster than a stored procedure?
What is consistency?
What is the largest value that can be stored in a byte data field?
What do you know by pl/sql cursors?
How to assign sql query results to pl sql variables?
How many sql core licenses do I need?
How to handle bulk data?
What is database white box testing and black box testing?
List out the acid properties and explain?
Which join is default?
How to run sql statements with oracle sql developer?
What is difference between stored procedure and trigger?