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
- 11726 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
What are the advantages of sql? Explain
How to rename a column in the output of sql query?
What are the differences between in and exists clause?
How do I find sql profiler?
What are the parts of a basic sql query?
What are the different tcl commands in sql?
What is difference between function and trigger?
Explain lock escalation? : Transact sql
What are some predefined exceptions in pl/sql?
What is the difference between delete and truncate statement in sql?
Can we create clustered index without primary key?
How does index help in query performance?
Why do we use cursors?
explain what is mysql? : Sql dba
Can a view be mutating? If yes, then how?
