3
Answers

Update and Delete Constrains on same foreign key

Zeb Rehman

Zeb Rehman
13y
2.2k
1
Hello everybody, Can some body tell me how ca i apply the following two constrains on same foreign key.......

  • CASCADE ON DELETE
  • CASCADE ON UPDATE
On following table of Users

CREATE TABLE User_Type(
Type_ID int primary key,
Type_Name char(50)
);

CREATE TABLE Users(
USer_ID int primary key,
User_Name char(50),
User_Type int references User_Type(Type_ID) /*Here i want to apply those two constrains*/
);
Answers (3)
Next Recommended Forum