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
- 11782 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 a sql select statement?
How do you copy a table in sql?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
Is t sql a programming language?
Can we use views in stored procedure?
how is myisam table stored? : Sql dba
Define implicit and explicit cursors.
What are analytic functions in sql?
Enlist the advantages of sql.
What are the advantages of stored procedure?
What is pl sql in dbms?
What are sql triggers used for?
What are the two parts of design view?
Does google use sql?
Does truncate require commit?
