How to add Foreign key in a table after the creation of the
table?
Answer Posted / subbu
You cannot add foreign key after creation of the table until
unless you have assigned the primary key while creating the
table. I mean without a primary key assigned for a table, we
cannot add foreign key.
Once the primary key is found, then query to add is been
already given by the above posters.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is meaning of <> in sql?
Is full outer join same as cross join?
Does sql full backup truncate logs?
What packages(if any) has oracle provided for use by developers?
What is query syntax?
Explain the uses of database trigger.
Explain the order of sql statement execution?
Explain autonomous transaction.
What is a trigger word?
Is sql procedural language?
What is trigger with example?
What is the difference among union, minus and intersect?
How to display Row Number with Records in Oracle SQL Plus?
What version is sql?
How to raise user-defined exception with custom sqlerrm ?