we can add a foreign key to a table 1)while creation of table 2)After th

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

Question Posted / purushotham

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

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I save a sql query?

1018

Which is faster count (*) or count 1?

1036

What is cross join sql?

921

Explain the difference between triggers and constraints?

979

Can we update views in sql?

942

Is primary key an index?

996

Why do we use sqlite?

985

what are wild cards used in database for pattern matching ? : Sql dba

1145

What is scalar function in sql?

1044

Explain alias in sql?

1051

Why is a trigger used?

945

What is secondary key?

935

How can I tell if sql is running?

1067

Can procedure in package be overloaded?

1086

How do temporal tables work?

964