if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[合同變動子集_勞動合同編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[合同變動子集] DROP CONSTRAINT 合同變動子集_勞動合同編號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[合同補充子集_勞動合同編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[合同補充子集] DROP CONSTRAINT 合同補充子集_勞動合同編號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[合同解除子集_勞動合同編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[合同解除子集] DROP CONSTRAINT 合同解除子集_勞動合同編號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[合同續簽子集_勞動合同編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[合同續簽子集] DROP CONSTRAINT 合同續簽子集_勞動合同編號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[合同終止子集_勞動合同編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[合同終止子集] DROP CONSTRAINT 合同終止子集_勞動合同編號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[勞動爭議子集_勞動合同編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[勞動爭議子集] DROP CONSTRAINT 勞動爭議子集_勞動合同編號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[干部調整與交流子集_職員編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[干部調整與交流子集] DROP CONSTRAINT 干部調整與交流子集_職員編號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[個人簡歷子集_職員編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[個人簡歷子集] DROP CONSTRAINT 個人簡歷子集_職員編號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[個人年度匯總臺帳子集_職員編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[個人年度匯總臺帳子集] DROP CONSTRAINT 個人年度匯總臺帳子集_職員編號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[合同管理子集_職員編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[合同管理子集] DROP CONSTRAINT 合同管理子集_職員編號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[兼任職務子集_職員編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[兼任職務子集] DROP CONSTRAINT 兼任職務子集_職員編號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[軍轉干部子集_職員編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[軍轉干部子集] DROP CONSTRAINT 軍轉干部子集_職員編號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[離休退休子集_職員編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[離休退休子集] DROP CONSTRAINT 離休退休子集_職員編號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[社會保險子集_職員編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[社會保險子集] DROP CONSTRAINT 社會保險子集_職員編號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[生育保險信息子集_職員編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[生育保險信息子集] DROP CONSTRAINT 生育保險信息子集_職員編號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[失業保險信息子集_職員編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[失業保險信息子集] DROP CONSTRAINT 失業保險信息子集_職員編號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[行政黨派職務子集_職員編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[行政黨派職務子集] DROP CONSTRAINT 行政黨派職務子集_職員編號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[行政及黨內懲罰_職員編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[行政及黨內懲罰] DROP CONSTRAINT 行政及黨內懲罰_職員編號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[行政及黨內獎勵_職員編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[行政及黨內獎勵] DROP CONSTRAINT 行政及黨內獎勵_職員編號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[學歷及學位子集_職員編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[學歷及學位子集] DROP CONSTRAINT 學歷及學位子集_職員編號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[養老保險信息子集_職員編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[養老保險信息子集] DROP CONSTRAINT 養老保險信息子集_職員編號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[醫療保險子集_職員編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[醫療保險子集] DROP CONSTRAINT 醫療保險子集_職員編號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[政治面貌及黨籍情況_職員編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[政治面貌及黨籍情況] DROP CONSTRAINT 政治面貌及黨籍情況_職員編號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[職工參險信息子集_職員編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[職工參險信息子集] DROP CONSTRAINT 職工參險信息子集_職員編號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_職員離職登記表_職員基本信息表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[職員離職登記表] DROP CONSTRAINT FK_職員離職登記表_職員基本信息表
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[職員主要關系人信息表_職員編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[職員主要關系人信息表] DROP CONSTRAINT 職員主要關系人信息表_職員編號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[主要論文著作子集_職員編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[主要論文著作子集] DROP CONSTRAINT 主要論文著作子集_職員編號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[住房公積金子集_職員編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[住房公積金子集] DROP CONSTRAINT 住房公積金子集_職員編號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[專業技術職務子集_職員編號_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[專業技術職務子集] DROP CONSTRAINT 專業技術職務子集_職員編號_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[上年工資統計]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[上年工資統計]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[專業技術職務子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[專業技術職務子集]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[個人年度匯總臺帳子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[個人年度匯總臺帳子集]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[個人所得稅表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[個人所得稅表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[個人簡歷子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[個人簡歷子集]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[主要論文著作子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[主要論文著作子集]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[人事變更歷史表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[人事變更歷史表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[住房公積金子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[住房公積金子集]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[養老保險信息子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[養老保險信息子集]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[兼任職務子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[兼任職務子集]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[軍轉干部子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[軍轉干部子集]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[刷卡記錄表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[刷卡記錄表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[加班歷史表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[加班歷史表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[勞動爭議子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[勞動爭議子集]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[醫療保險子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[醫療保險子集]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[單位人員基本結構子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[單位人員基本結構子集]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[單位人員編制子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[單位人員編制子集]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[單位參統信息子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[單位參統信息子集]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[單位月度匯總臺帳子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[單位月度匯總臺帳子集]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[單位機構情況子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[單位機構情況子集]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[單位離退休情況子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[單位離退休情況子集]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[單位職務結構子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[單位職務結構子集]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[合同變動子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[合同變動子集]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[合同管理子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[合同管理子集]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[合同終止子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[合同終止子集]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[合同續簽子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[合同續簽子集]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[合同補充子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[合同補充子集]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[合同解除子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[合同解除子集]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[固定扣繳項目調整表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[固定扣繳項目調整表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[基本養老保險費列表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[基本養老保險費列表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[基本醫療保險費列表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[基本醫療保險費列表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[基本工資調整表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[基本工資調整表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[失業保險信息子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[失業保險信息子集]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[失業保險費列表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[失業保險費列表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[學歷及學位子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[學歷及學位子集]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[崗位變更子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[崗位變更子集]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[工傷信息子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[工傷信息子集]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[工資統計歷史表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[工資統計歷史表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[工齡工資調整表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[工齡工資調整表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[干部調整與交流子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[干部調整與交流子集]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[應聘人員分類編碼表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[應聘人員分類編碼表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[應聘人員錄用表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[應聘人員錄用表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[應聘人員登記表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[應聘人員登記表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[當月加班費列表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[當月加班費列表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[當月獎金列表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[當月獎金列表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[當月扣繳項目列表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[當月扣繳項目列表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[當月福利列表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[當月福利列表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[當月考核工資列表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[當月考核工資列表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[招聘初選歷史表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[招聘初選歷史表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[招聘初選名單表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[招聘初選名單表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[招聘申請歷史表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[招聘申請歷史表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[招聘申請表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[招聘申請表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[招聘計劃表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[招聘計劃表]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[政治面貌及黨籍情況]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[政治面貌及黨籍情況]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[教育經歷證書列表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[教育經歷證書列表]