alter table t3
add constraint fk_t3 foreign key(sid) references(t1.sid)
alter table t2
add constraint fk_t2 foreign key(sid) references(t1.sid)
add constraint fk_t3 foreign key(sid) references(t1.sid)
alter table t2
add constraint fk_t2 foreign key(sid) references(t1.sid)
解决方案 »
- 怎样修改?改了很多次都不行!
- 又送分了....
- sql 跟踪监控问题
- VC SQL中where后面的变量怎么写
- SQL2000在安装选择,验证模式后自动退出.
- select * from tz_jy where f_draw_no not in (select f_draw_no from tz_info )为何没数据?
- 我要把客户上忆的数据由excel导入到sql表中,我通过sql工具导入到sql2005中,可是我想建立表字段的约束时,不能实现,也不可以为表建立主键,这样表之
- 关于存储过程带参数的问题
- SQL2000重新安装 疑难问题
- 表结构设计问题?
- 谁能帮我写这个sql语句啊?
- 各位老大救急啊!sqlserver无法起动
add constraint fk_t3 foreign key(sid) references(t1.sid)
on delete on update
alter table t2
add constraint fk_t2 foreign key(sid) references(t1.sid)
on delete on update
add constraint fk_t3 foreign key(sid) references(t1.sid)
on delete cascade
on update cascade
alter table t2
add constraint fk_t2 foreign key(sid) references(t1.sid)
on delete cascade
on update cascade