How to add Foreign key in a table after the creation of the
table?
- 5 Answers
- 10757 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / purushotham
we can add a foreign key to a table
1)while creation of table
2)After the creation of the table
by using
Alter table table_name add foreign key(column_name)
References column_name from table_name(that consists of
primary key)
| Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
Why is a trigger used?
How many types of functions are there in sql?
how to check server status with 'mysqladmin'? : Sql dba
How will you distinguish a global variable with a local variable in pl/sql?
State few characteristics of pl/sql?
What are pl/sql cursors?
What is database migration?
Can a table contain multiple foreign key’s?
Which are the different character-manipulation functions in sql?
how to get help information from the server? : Sql dba
What is left inner join in sql?
What is sap sql?
What are the benefits of triggers?
Explain how can you save or place your msg in a table?
What is online transaction processing (oltp)?
