USE 工时管理
goif exists(select * from dbo.sysobjects where id=object_id(N'[dbo].[FK_每日工时_员工信息]')and OBJECTPROPERTY(id,N'IsForeignKey') =1)
BEGIN
ALTER TABLE [dbo].[每日工时] DROP CONSTRAINT FK_每日工时_员工信息
END
GOif exists(select * from dbo.sysobjects where id=object_id(N'[dbo].[公司工作项目]')and OBJECTPROPERTY(id,N'IsForeignKey')=1)
BEGIN
drop table[dbo].[公司工作项目]
END
GOif exists(select * from dbo.sysobjects where id=object_id(N'[dbo].[员
工信息]')and OBJECTPROPERTY(id,N'IsForeignKey')=1)
BEGIN
drop table[dbo].[员工信息]
END
goif exists(select * from dbo.sysobjects where id=object_id(N'[dbo].[FK_每日工时_员工信息]')and OBJECTPROPERTY(id,N'IsForeignKey') =1)
BEGIN
ALTER TABLE [dbo].[每日工时] DROP CONSTRAINT FK_每日工时_员工信息
END
GOif exists(select * from dbo.sysobjects where id=object_id(N'[dbo].[公司工作项目]')and OBJECTPROPERTY(id,N'IsForeignKey')=1)
BEGIN
drop table[dbo].[公司工作项目]
END
GOif exists(select * from dbo.sysobjects where id=object_id(N'[dbo].[员
工信息]')and OBJECTPROPERTY(id,N'IsForeignKey')=1)
BEGIN
drop table[dbo].[员工信息]
END
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货