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)
);
Loading
Zeb RehmanPosted Apr 26, 2011, 3:47 AM
Ankit NandekarPosted Apr 26, 2011, 3:28 AM
http://www.java2s.com/Code/SQLServer/Constraints/DELETECASCADEandUPDATECASCADE.htm
Madhu KPosted Apr 26, 2011, 3:17 AM
Delete records with JOIN