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

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

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

Question Posted / sourisengupta

5 Answers
10006 Views
Satyam, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / 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

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

Answer / 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

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

Answer / devi

alter table table2
add(constraint table2_col2_fk foreign key(col2) references
table1(col1);
here col2 is the foreign key of table2 which refer to the
col1 of table1 which is h epimary key of table1

Is This Answer Correct ?

3 Yes

0 No

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

Answer / subbu

You cannot add foreign key after creation of the table until
unless you have assigned the primary key while creating the
table. I mean without a primary key assigned for a table, we
cannot add foreign key.

Once the primary key is found, then query to add is been
already given by the above posters.

Is This Answer Correct ?

2 Yes

2 No

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

Answer / venkatesh

u have create two tables an the time one in first table must an should using primary key .in way of using ddl cmd.
A)alter table table name add fk(clm name) reference column name from table name consists of primary key

Is This Answer Correct ?

0 Yes

0 No

Post New Answer