Dear all.. I try to make this SQL code to work but the follwing Error raise, so can any one help me.......? NOTE: when i add the constraint only the code work properly but the cascade delete does not work ..,so i try to add (ON DELETE CASCADE) but it raises the following error. ---------------------------Syntax--------------------------------- alter table messages add constraint fk_test foreign key(pid) references lineitems(pid) on delete cascade -------------------------------End--------------------------------- ----------------------------The Error is-------------------------- Server: Msg 156, Level 15, State 1, Line 2 Incorrect syntax near the keyword 'on'. -----------------------------End----------------------------------- MR.Eyad Makhoul TelNo/Home:+96265359801 Mobile:+96277304797 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
