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 log shipping? : Sql dba
how to drop an existing view in mysql? : Sql dba
Why do we use set serveroutput on?
Is a foreign key always unique?
What is normalisation in sql?
What is trigger explain with example?
what are set operators in sql? : Sql dba
What are the types of sql commands?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
What is application trigger?
What are the 3 modes of parameter?
Name three sql operations that perform a sort.
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
How to run pl sql program in mysql?
Will truncate release space?