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
What is sql server and ase?
what is top in tsql? : Transact sql
What is dialect in sql?
Which is better cte or subquery?
What is the difference between delete, truncate and drop command?
What are triggers in sql?
What are the disadvantages of not performing database normalization?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
What is trigger types in sql?
what are dynamic queries in t-sql? : Transact sql
What is materialized view in sql?
What are synonyms in sql?
explain the options of myisamchk to improve the performance of a table. : Sql dba
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
What is sql profiling in oracle?