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
- 11942 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
How many tables can you join in sql?
Why do you partition data?
what happens if null values are involved in expressions? : Sql dba
What is pl/sql language case sensitive?
What is embedded sql with example?
Explain how to use transactions efficiently : transact sql
What is difference between cursor and trigger?
What is out parameter used for eventhough return statement can also be used in pl/sql?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
Is sql a backend language?
Is full outer join same as cross join?
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
What are the datatypes available in pl/sql ?
how do you know the version of your mysql server? : Sql dba
Can a table contain multiple foreign key’s?
