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

What is crud stand for?

1049

Enlist the characteristics of pl/sql?

1846

What is graph sql?

1039

Which table is left in join?

1017

how to see the create table statement of an existing table? : Sql dba

1060

What is varray in pl sql?

1123

how do you know if your mysql server is alive? : Sql dba

1130

What is difference between db2 and sql?

1046

What is the difference between clustered and non-clustered indexes?

1132

what is try_catch block in procedure

1811

what is sql profiler? : Sql dba

1115

Name some usages of database trigger?

1086

What is AUTH_ID and AUTH_USER in pl/sql ?

2237

How do you optimize a query?

1060

What trigger means?

1036