How to add Foreign key in a table after the creation of the
table?
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 field types?
Does view store data in sql?
What is a subquery in sql?
How do I filter in sql profiler?
What is cross join sql?
What is file based approach?
what is the command used to fetch first 5 characters of the string? : Sql dba
What is Collation Sensitivity ? What are the various type ?
What is sql mysql pl sql oracle?
What is package in pl sql?
What is cartesian join in sql?
Explain the steps needed to create the scheduled job?
What is trigger price?
What is sql key?
Is sql pronounced sequel or sql?