ALTER TABLE <table_name> ADD CONSTRAINT <fk

How to add Foreign key in a table after the creation of the
table?

Question Posted / sagar98

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

Please Help Members By Posting Answers For Below Questions

How do I run sql?

1177

What is java sql package?

1090

how tsql statements can be written and submitted to the database engine? : Transact sql

987

What is scalar function?

1050

what is a composite key ? : Sql dba

1045

how do you know the version of your mysql server? : Sql dba

1002

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1217

What is output spooling in sql*plus?

1030

Mention what does plv msg allows you to do?

1107

how can you see all indexes defined for a table? : Sql dba

992

How do you rank data in sql?

1000

What is a boolean in sql?

977

what are sequences

1741

What is left inner join in sql?

1041

What is aggregate function in sql?

1032