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 would you convert date into julian date format?

1004

How can a function retun more than one value in oracle with proper example?

1074

What is the difference between pl and sql?

1093

Why should I use postgresql?

1013

What are the datatypes available in pl/sql ?

1103

What is the difference between rollback and rollback to statements?

1060

How can we implement rollback or commit statement in a trigger?

1034

What do you mean by dbms? What are its different types?

1018

Does access use sql?

1039

What is the difference between explicit and implicit cursors in oracle?

1068

Is join same as left join?

1037

What is difference between ms sql and mysql?

963

What is normalization in sql?

1010

How do you get column names only for a table (sql server)?

1161

what is oracle database ? : Sql dba

1026