What is the difference between the Primary and Foreign key?
Answer Posted / nitin
Primary key uniquely identified a record in a table and dont have null values. Also when we create primary key an index is automatically created for primary key.
On the other hand foreign key is used for referential integrity, foreign key can points to primary key in other table and moreover index is not created for foreign key.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
describe mysql connection using mysql binary. : Sql dba
What are the 3 types of behavioral triggers?
what is denormalization. : Sql dba
Can we use view in stored procedure?
Is postgresql a server?
Why stored procedure is better than query?
What is rollback?
What are the benefits of stored procedures?
What is sqlservr exe?
How do you update a value in sql?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
How can you load multi line records? : aql loader
What are reports usually used for?
How can I tell if sql is running?
Does group by remove duplicates?