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
- 11727 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 bcp? When does it used? : Sql dba
Why do we need databases?
What is delimiter sql?
What is program debugging?
How long will it take to learn pl sql?
What is a pl/sql block?
What is view explain with example?
What has stored procedures in sql and how we can use it?
How do I audit the sql sent to the server?
How to test for null values?
What is null in pl/sql?
how do you know if your mysql server is alive? : Sql dba
What is constant in pl sql?
what is the syntax used for partition in tsql? : Transact sql
Can we call dml statement in function?
