请假系统完整文件加英文论文

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_tbl_EmpDetails_tbl_City]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[tbl_EmpDetails] DROP CONSTRAINT FK_tbl_EmpDetails_tbl_City GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_tbl_City_tbl_Country]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[tbl_CityDetails] DROP CONSTRAINT FK_tbl_City_tbl_Country GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_tbl_EmpDetails_tbl_Country]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[tbl_EmpDetails] DROP CONSTRAINT FK_tbl_EmpDetails_tbl_Country GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_tbl_State_tbl_Country]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[tbl_State] DROP CONSTRAINT FK_tbl_State_tbl_Country GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_tbl_EmpDetails_tbl_Dept]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[tbl_EmpDetails] DROP CONSTRAINT FK_tbl_EmpDetails_tbl_Dept GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_tbl_ApplicationData_tbl_LeaveType]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[tbl_ApplicationData] DROP CONSTRAINT FK_tbl_ApplicationData_tbl_LeaveType GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_tbl_LeaveDetails_tbl_LeaveType]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[tbl_LeaveDetails] DROP CONSTRAINT FK_tbl_LeaveDetails_tbl_LeaveType GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_tbl_City_tbl_State]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[tbl_CityDetails] DROP CONSTRAINT FK_tbl_City_tbl_State GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_tbl_EmpDetails_tbl_State]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[tbl_EmpDetails] DROP CONSTRAINT FK_tbl_EmpDetails_tbl_State GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_tbl_ApplicationData_tbl_Status]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[tbl_ApplicationData] DROP CONSTRAINT FK_tbl_ApplicationData_tbl_Status GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_tbl_City_tbl_Status]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[tbl_CityDetails] DROP CONSTRAINT FK_tbl_City_tbl_Status GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_tbl_Country_tbl_Status]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[tbl_Country] DROP CONSTRAINT FK_tbl_Country_tbl_Status GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_tbl_State_tbl_Status]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[tbl_State] DROP CONSTRAINT FK_tbl_State_tbl_Status GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_tbl_ApplicationData_tbl_Users]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[tbl_ApplicationData] DROP CONSTRAINT FK_tbl_ApplicationData_tbl_Users GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_tbl_EmpDetails_tbl_Users]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[tbl_EmpDetails] DROP CONSTRAINT FK_tbl_EmpDetails_tbl_Users GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_tbl_LeaveDetails_tbl_Users]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[tbl_LeaveDetails] DROP CONSTRAINT FK_tbl_LeaveDetails_tbl_Users GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spAddEmployee]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[spAddEmployee] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spAddLea�