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 plpgsql language?

1055

What do you think about pl/sql?

1020

What are pl sql procedures?

1020

Does sql require a server?

1005

Is sql pronounced sequel or sql?

1260

Is sql sequential or random?

1026

Does normalization improve performance?

1031

What is difference between group by and partition by?

1054

i have some prob lem to tell me about my self in interview first round ...

2158

How to create a menu in sqlplus or pl/sql?

1117

How do I order by ascending in sql?

1005

Can you call pl/sql package functions from within a fast formula?

1033

How long it takes to learn pl sql?

1007

what is the difference between blob and text? : Sql dba

1011

What is the difference between sql and mysql?

1115