I do not wha t is the error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

I do not wha t is the error

Author

Topic

B5CSE
Starting Member

25 Posts

Posted - 2005-05-01 : 05:22:44

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

when I execute that code then the erroe message occure

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.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-05-01 : 07:33:32

Please do not cross post:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49143

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources