?? 人力資源管理.sql

?? 用ＳＱＬ制作的　人力資源管理程序系統(tǒng)
?? SQL
?? 第 1 頁 / 共 5 頁
字號(hào):
12 3 4 5 下一頁
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[合同變動(dòng)子集_勞動(dòng)合同編號(hào)_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[合同變動(dòng)子集] DROP CONSTRAINT 合同變動(dòng)子集_勞動(dòng)合同編號(hào)_fk
GO

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[行政及黨內(nèi)獎(jiǎng)勵(lì)_職員編號(hào)_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[行政及黨內(nèi)獎(jiǎng)勵(lì)] DROP CONSTRAINT 行政及黨內(nèi)獎(jiǎng)勵(lì)_職員編號(hào)_fk
GO

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

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

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

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

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[職工參險(xiǎn)信息子集_職員編號(hào)_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[職工參險(xiǎn)信息子集] DROP CONSTRAINT 職工參險(xiǎn)信息子集_職員編號(hào)_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].[職員主要關(guān)系人信息表_職員編號(hào)_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[職員主要關(guān)系人信息表] DROP CONSTRAINT 職員主要關(guān)系人信息表_職員編號(hào)_fk
GO

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

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

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

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

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

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

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

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[個(gè)人簡(jiǎn)歷子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[個(gè)人簡(jiǎn)歷子集]
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].[養(yǎng)老保險(xiǎn)信息子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[養(yǎng)老保險(xiǎn)信息子集]
GO

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

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[軍轉(zhuǎn)干部子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[軍轉(zhuǎn)干部子集]
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].[勞動(dòng)爭(zhēng)議子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[勞動(dòng)爭(zhēng)議子集]
GO

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

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[單位人員基本結(jié)構(gòu)子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[單位人員基本結(jié)構(gòu)子集]
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].[單位參統(tǒng)信息子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[單位參統(tǒng)信息子集]
GO

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

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[單位機(jī)構(gòu)情況子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[單位機(jī)構(gòu)情況子集]
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].[單位職務(wù)結(jié)構(gòu)子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[單位職務(wù)結(jié)構(gòu)子集]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[合同變動(dòng)子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[合同變動(dòng)子集]
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].[合同續(xù)簽子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[合同續(xù)簽子集]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[合同補(bǔ)充子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[合同補(bǔ)充子集]
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].[固定扣繳項(xiàng)目調(diào)整表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[固定扣繳項(xiàng)目調(diào)整表]
GO

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

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

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

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

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

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[學(xué)歷及學(xué)位子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[學(xué)歷及學(xué)位子集]
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].[工資統(tǒng)計(jì)歷史表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[工資統(tǒng)計(jì)歷史表]
GO

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

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

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

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

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

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

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

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

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

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[當(dāng)月考核工資列表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[當(dāng)月考核工資列表]
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].[招聘申請(qǐng)歷史表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[招聘申請(qǐng)歷史表]
GO

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

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[招聘計(jì)劃表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[招聘計(jì)劃表]
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].[教育經(jīng)歷證書列表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[教育經(jīng)歷證書列表]
12 3 4 5 下一頁
?? 文件大小 396 K
?? 上傳用戶 shanon
?? 所屬分類 SQL Server
??? 相關(guān)標(biāo)簽

#人力資源 #程序
?? 快捷鍵說明

復(fù)制代碼 Ctrl + C
搜索代碼 Ctrl + F
全屏模式 F11
切換主題 Ctrl + Shift + D
顯示快捷鍵 ?
增大字號(hào) Ctrl + =
減小字號(hào) Ctrl + -
亚洲欧美第一页_禁久久精品乱码_粉嫩av一区二区三区免费野_久草精品视频

?? 人力資源管理.sql

?? 快捷鍵說明
