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 the least restrictive isolation level? : Transact sql

1070

Show the cursor attributes of pl/sql.

1051

What are schema-level triggers?

1104

What does the hierarchical profiler does?

1062

What is clustered and nonclustered index in sql?

944

What is a mutating table and a constraining table?

1117

What is the most common sql injection tool?

1044

how many groups of data types? : Sql dba

1029

Can we join more than 2 tables in sql?

1024

What do we need to check in database testing?

1022

What is data type in sql?

967

When do we use triggers?

1084

Which is better join or inner query?

1054

How to disable a trigger name update_salary?

1267

What is the basic structure of an sql?

1103