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 the sql commands?
Is sql microsoft?
What is the size of partition table?
Can instead of triggers be used to fire once for each statement on a view?
What are sql built in functions?
How would you convert date into julian date format?
Can you do multiple joins in sql?
what is bdb (berkeleydb)? : Sql dba
What is the purpose of normalization?
What is attribute indicator in pl sql?
How do you update sql?
What is a schema sql?
Explain what is a column in a table?
What is sql data?
What is anonymous block in sql?