How to add foreign key constraint to a table or column

 How to add foreign key constraint to a table or column

ADD FOREIGN KEY

টেবিল তৈরীর পরে FOREIGN KEY CONSTRAINT ADD করা ।

SQL>alter table pr_detail

add constraint fk_prtn_id foreign key (pr_id) references pr_master(pr_id)

Table altered.

 

Not null constraint

Unique key constraint

Primary key constraint