How to add Foreign key in a table after the creation of the
table?
- 5 Answers
- 10031 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / sagar98
ALTER TABLE <table_name>
ADD CONSTRAINT <fk_name> FOREIGN KEY (column_name)
REFERENCES <table_name_where_this_column_acts_as_PK>
(Column_name)
| Is This Answer Correct ? | 19 Yes | 0 No |
Post New Answer View All Answers
what are the 'mysql' command line arguments? : Sql dba
In pl/sql, what is bulk binding, and when/how would it help performance?
Can we join two tables without common column?
How do you update f as m and m as f from the below table testtable?
What is difference between procedure and trigger?
What is pl sql block structure?
What does stand for in sql?
What are triggers in sql?
how to extract a unit value from a date and time? : Sql dba
How much does sql certification cost?
Is mariadb nosql?
What is compilation error in pl sql?
What does select * from mean in sql?
Explain constraints in sql?
What are procedures used for?
