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
What is flag in sql?
Explain select statements in sql?
What are the qualities of 2nf?
Why we use stored procedure instead of query?
What is a ddl command?
Are views faster than queries?
What is data definition language?
What is the use of procedures?
What are system versioned tables?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
Which version of sql do I have?
How do you bind variables in pl sql?
Which sorts rows in sql?
how would you enter characters as hex numbers? : Sql dba
what are numeric data types? : Sql dba