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
Is sql developer case sensitive?
How do you delete data from a table?
Is sqlite free?
What is int identity in sql?
What is tuple in sql?
What is indexes?
How do I debug a stored procedure?
How do we use distinct statement? What is its use?
How do you concatenate in sql?
What are the advantages of pl sql?
Which data dictionary views have the information on the triggers that are available in the database?
How many types of literals are available in pl sql?
what does the t-sql command ident_incr does? : Transact sql
What are the advantages of sql?
What does (+) mean in sql joins?