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
What is the usage of distinct keyword?
How do I run a script in sql developer?
What is the location of pre_defined_functions.
How do you select unique values in sql?
what is the difference between undefined value and null value? : Sql dba
What do you mean by stored procedures? How do we use it?
How do I send sql query results to excel?
Which sql statement is used to return only different values?
What is a memo field?
What are the advantages of pl sql over sql?
What trigger means?
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
What is dialect in sql?
what is the different between now() and current_date()? : Sql dba
What is serial sql?