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
Can we use view in stored procedure?
Is pl sql and postgresql same?
What is synonyms?
How many columns should be in an index?
What is meant by <> in sql?
how to get @@error and @@rowcount at the same time? : Sql dba
What is pl sql package?
What is an escape character in sql?
Why primary key is required?
How do I audit the sql sent to the server?
How is data stored on a disk?
Is pl sql a scripting language?
what is 'mysqlcheck'? : Sql dba
what is rollback? : Sql dba
what is try_catch block in procedure