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
- 11937 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 we use sql profiler?
What is keys and its types?
Can we perform dml in function?
How do you concatenate in sql?
What is normalization in sql?
What does pl sql developer do?
Inline the values in PL/SQL, what does it mean.?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
Why primary key is required?
What are few of the schema objects that are created using PL/SQL?
What are some emotional triggers?
What is Difference Between Unique and Primary Key Constraints?
What is procedure and function?
What is example of database?
What is the requirement of self-join?
