创建关系图出错,急!!!
2个表table1,table2
分别是
CREATE TABLE [TABLE1] (
[tbl_id] [int] IDENTITY (1, 1) PRIMARY,
[tbl_name] [varchar] (50) NOT NULL ,
[tbl_other1] [int] NOT NULL ,
[tbl_other2] [int] NOT NULL
)
CREATE TABLE [TABLE2] (
[tbl_id] [int] IDENTITY (1, 1) PRIMARY ,
[tbl_name] [char] (10) NOT NULL
)
当我把tbl_othen1 和 tbl_other2 的主键都设为 TABLE2 的tbl_id 时候出错
出错信息是
[Microsoft][ODBC SQL Server Driver][SQL Server]将 FOREIGN KEY 约束 'FK_TABLE1_TABLE21' 引入表 'TABLE1' 中将导致循环或多重级联路径。请指定 ON DELETE NO ACTION 或 ON UPDATE NO ACTION,或修改其它 FOREIGN KEY 约束