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 native sql query?
What does varchar include?
What is the difference between sum and count in sql?
Explain mutating table error.
what are the properties and different types of sub-queries? : Sql dba
How do you write an index?
What is nvl?
What is sql query limit?
What is nvarchar max in sql?
How do you determine the current isolation level? : Transact sql
What is pl/sql language case sensitive?
What will you get by the cursor attribute sql%notfound?
How can you get sql*loader to commit only at the end of the load file? : aql loader
Which are the different case manipulation functions in sql?
What are keys in sql?