What is the difference between the Primary and Foreign key?
Answer Posted / dhirendra
Primary Key: This is a constraint which is always unique &
not null.
Foreign Key: This is a constraint which is just opposite to
Primary key. It can be not Null & can accept duplicate value
as well. Foreign key points to same table's primary key or
another table's primary key to make a relationship.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Why left join is used in sql?
Which normal form is best?
What is oracle sql called?
What are the parts of a sql statement?
How global cursor can be declare with dynamic trigger ?
What are the advantages of indexing?
What are all the different types of indexes?
How do I send sql query results to excel?
What are inner and outer joins examples of both?
What is sql in oracle?
Does oracle use sql?
Can we use pl sql in mysql?
How do I sort a table in sql?
What is the difference between nvl function, ifnull function, and isnull function?
What is the sql*loader? : aql loader