بسم الله الرحمن الرحيم
ماهو الخطأ في هذا الكود
use banking create table hesab_tawfeer ( id int foreign key references clients(id) on update no action , f_name varchar(20) not null , s_name varchar(20) not null , th_name varchar(20) not null , la_name varchar(20) not null , sav_code smallint not null foreign key references coding(sav_code) on update cascade , br_code smallint not null foreign key references coding(br_code) on update cascade , currency varchar(10), money_amount money, period_baring varchar(20), date datetime default getdate() )
حيث تظهر لي رسالة الخطا التالية
Server: Msg 1785, Level 16, State 1, Line 2 Introducing FOREIGN KEY constraint 'FK__hesab_taw__br_co__1920BF5C' on table 'hesab_tawfeer' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints. Server: Msg 1750, Level 16, State 1, Line 2 Could not create constraint. See previous errors.
و جزاكم الله خيرا