Interested to Buy Any Domain ? << Click Here >> for more details...
How to add Foreign key in a table after the creation of the
table?
- 5 Answers
- 11762 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 msql? : Sql dba
What is difference between sql and mysql?
Is left join same as inner join?
What is localdb mssqllocaldb?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
Where not exists in sql?
Which join is like an inner join?
Explain what is a field in a database and record in a database?
What is $$ in sql?
What is the difference between function and procedure in pl/sql?
explain what is mysql? : Sql dba
Show how functions and procedures are called in a pl/sql block.
What is data control language (dcl)?
What is pl/sql table? Why is it used?
How many row comparison operators are used while working with a subquery?
