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
- 11742 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
Which is better stored procedure or query?
What is union and union all keyword in sql and what are their differences?
How to return an array from java to pl/sql?
What is basic structure of pl sql?
What is the difference between numeric and autonumber?
What is t sql used for?
Is trigger a stored procedure?
What are local and global Indexes and where they are useful.
What is an oracle stored procedure?
Which is faster union or join?
What steps server process has to take to execute an update statement?
What is record type in pl sql?
What is not null in sql?
What is a primary key called that is made up of more than one field?
How do I tune a sql query?
