62,041
社区成员
发帖
与我相关
我的任务
分享
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_l_lanmu_l_catelog]') and objectproperty(id, N'IsForeignKey') = 1)
alter table [dbo].[l_lanmu] drop constraint FK_l_lanmu_l_catelog
alter table [dbo].[l_lanmu] add constraint [FK_l_lanmu_l_catelog] foreign key ([l_cid]) references [dbo].[l_catelog] ([l_cid]) on delete cascade 目表分类