check约束

alter table xsa_xsjbqk

add

constraint pk_1 primary key (id)

alter table xsa_xsgkcj

add

constraint fk_1 foreign key (xid) references xsa_xsjbqk (id) on delete cascade on update cascade

(商品编号 varchar(20) not null  PRIMARY KEY CLUSTERED REFERENCES 主表 (编号)  ON DELETE  CASCADE  ON UPDATE CASCADE ,
商品名称 varchar(20) ,

select * from xsa_xsjbqk

select * from xsa_xsgkcj

insert