dropnb.sql

一个用VB写的财务软件源码

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TFZ_KMXMFILTER<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TFZ_KMXMFILTER<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TFZ_XMBMPZSJ<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TFZ_XMBMPZSJ<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TFZ_EXPANDPZSJ<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TFZ_EXPANDPZSJ<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[vfz_expandpzsj<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop view [dbo].[vfz_expandpzsj<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGD_BALANCE<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TGD_BALANCE<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGD_plzd<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tgd_plzd<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TGD_DEPARTMENT<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TGD_DEPARTMENT<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TMR_DRAFT<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TMR_DRAFT<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TMR_DRAFTASSISTANT<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TMR_DRAFTASSISTANT<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TMR_OFFSET<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TMR_OFFSET<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TMR_OFFSETDATA<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TMR_OFFSETDATA<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TMR_OFFSETEQUAL<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TMR_OFFSETEQUAL<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TMR_OFFSETITEM<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TMR_OFFSETITEM<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TMR_OFFSETSUB<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TMR_OFFSETSUB<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TMR_REPORT<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TMR_REPORT<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TMR_REPORTDATA<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TMR_REPORTDATA<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TMR_TEMPLETDETAIL<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TMR_TEMPLETDETAIL<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TMR_TEMPLETMAIN<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TMR_TEMPLETMAIN<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TZW_BUDGET<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TZW_BUDGET<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TZW_BUDGETCONTROL<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TZW_BUDGETCONTROL<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TZW_IGENERALDATA<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TZW_IGENERALDATA<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TZW_IGENERALSTRUCT<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TZW_IGENERALSTRUCT<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TZW_PLAN<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TZW_PLAN<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TZW_PLUS<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TZW_PLUS<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Tusu_kmToXmClass<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Tusu_kmToXmClass<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tBB_ReportData<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tBB_ReportData<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tBB_ReportRemark<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tBB_ReportRemark<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tCF_OneOne<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tCF_OneOne<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tUSU_Department<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tUSU_Department<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tUSU_Fz<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tUSU_Fz<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tYSYF_BadAccountKm<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tYSYF_BadAccountKm<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tYSYF_Pzsj<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tYSYF_Pzsj<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tYsYf_FZ<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tYsYf_FZ<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tZW_AccountAge<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tZW_AccountAge<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tZW_BadAccountAge<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tZW_BadAccountAge<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tZW_Balance<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tZW_Balance<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tZW_Check<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tZW_Check<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tZW_Customer<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tZW_Customer<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tZW_CustomerClass<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tZW_CustomerClass<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tZW_CustomerShowSet<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tZW_CustomerShowSet<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tZW_Exch<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tZW_Exch<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tZW_ForeignCurrency<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tZW_ForeignCurrency<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tZW_Item<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tZW_Item<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tZW_ItemClass<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tZW_ItemClass<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tZW_Jsfs<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tZW_Jsfs<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tZW_Pzsj<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tZW_Pzsj<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tZW_TempletDetail<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tZW_TempletDetail<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tZW_TempletMain<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tZW_TempletMain<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tZW_Type<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tZW_Type<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tZW_Vendor<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tZW_Vendor<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tZW_VendorClass<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tZW_VendorClass<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tZW_VendorShowSet<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tZW_VendorShowSet<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tZW_Yhdzd<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tZW_Yhdzd<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tZW_Zzhdset<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tZW_Zzhdset<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tZW_ZzpzSet<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tZW_ZzpzSet<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tZW_km<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tZW_km<<YEAR>>]
;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tfx_reportdata<<YEAR>>]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tfx_reportdata<<YEAR>>]
;