Zeb Rehman

Zeb Rehman

  • NA
  • 69
  • 53.7k

Cascade Delete Simple question

Apr 26 2011 3:07 AM
Hi everybody, I have problem Regarding cascade delete. Can somebody please tell me the syntax for cascade delete at time of creation of table. I have following two tables Please modify them for cascade delete...

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)
);

Answers (3)