- CASCADE ON DELETE
- CASCADE ON UPDATE
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*/
);
Suthish NairPosted Apr 26, 2011, 9:14 AM
Zeb RehmanPosted Apr 26, 2011, 8:49 AM
That really help me......
Suthish NairPosted Apr 26, 2011, 7:28 AM