How to add Foreign key in a table after the creation of the
table?
- 5 Answers
- 10032 Views
- Satyam, I also Faced
- E-Mail Answers
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 a microsoft product?
How would you reference column values before and after you have inserted and deleted triggers?
how many ways to get the current time? : Sql dba
How to handle bulk data?
Sql technical questions
who introduced sql?
What is cross join example?
How does an execution block start and end in pl sql?
What are all ddl commands?
What does select count (*) mean in sql?
Is progress software supports to ( pl/sql )?
how to use like conditions? : Sql dba
Is it possible to pass parameters to triggers?
What is auto increment feature in sql?
What is the starting oracle error number?
