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 are different types of functions in sql?
How many types of normalization are there?
How subquery works in sql?
Is oracel sql developer written in java?
what are the advantages of using stored procedures? : Sql dba
Is null operator in sql?
What is the benefit of foreign key?
What does count (*) mean?
Why we use pl sql?
How many commands are in sql?
How can you fetch first 5 characters of the string?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
What is the file extension for sql database?
What is the difference between delete and truncate commands?
What are procedures used for?