How to add Foreign key in a table after the creation of the
table?
- 5 Answers
- 10033 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / devi
alter table table2
add(constraint table2_col2_fk foreign key(col2) references
table1(col1);
here col2 is the foreign key of table2 which refer to the
col1 of table1 which is h epimary key of table1
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is primary key in db?
How do I view tables in sql developer?
what is try_catch block in procedure
What are the different type of joins in sql?
What is the difference between distinct and unique in sql?
What is scope and visibility in PL/SQL?
What is a full join?
How do I find duplicates in two columns?
what are aggregate and scalar functions? : Sql dba
What is multiple partition?
What is a sql trace file?
Do prepared statements prevent sql injection?
Can a trigger call a stored procedure?
What is difference between left and right outer join?
Explain the purpose of %type and %rowtype data types?
