How to add Foreign key in a table after the creation of the
table?
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
How do I run sql?
What is java sql package?
how tsql statements can be written and submitted to the database engine? : Transact sql
What is scalar function?
what is a composite key ? : Sql dba
how do you know the version of your mysql server? : Sql dba
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
What is output spooling in sql*plus?
Mention what does plv msg allows you to do?
how can you see all indexes defined for a table? : Sql dba
How do you rank data in sql?
What is a boolean in sql?
what are sequences
What is left inner join in sql?
What is aggregate function in sql?