人力资源系统（delphi+sql2000）

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 CREATE TABLE [dbo].[部门表] ( [部门编号] [nvarchar] (3) COLLATE Chinese_PRC_CI_AS NOT NULL , [部门名称] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ) O�