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
- 11535 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
Does a join table need a primary key?
What is a database event trigger?
What is a rank in sql?
What are the ways on commenting in a pl/sql code?
What is sql partition function?
Which operator is used in query for pattern matching?
Is sql procedural language?
what is the difference between primary key and unique key? : Sql dba
What is difference between hql and native sql?
Why coalesce is used in sql?
Can we insert data into materialized view?
what are date and time data types? : Sql dba
What is the use of function "module procedure" in pl/sql?
Is microsoft sql free?
what are the disadvantages of mysql? : Sql dba
