dropnb.sql

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

Drop Table TBB_REPORTDATA<<YEAR>> cascade constraints;
Drop Table TBB_REPORTREMARK<<YEAR>> cascade constraints;
Drop Table TCF_ONEONE<<YEAR>> cascade constraints;
Drop Table TFX_REPORTDATA<<YEAR>> cascade constraints;
Drop Table TFZ_KMXMFILTER<<YEAR>> cascade constraints;
Drop Table TFZ_XMBMPZSJ<<YEAR>> cascade constraints;
Drop Table TFZ_EXPANDPZSJ<<YEAR>> cascade constraints;
Drop View vfz_expandpzsj<<YEAR>> cascade constraints;
Drop Table TGD_BALANCE<<YEAR>> cascade constraints;
Drop Table TGD_DEPARTMENT<<YEAR>> cascade constraints;
Drop Table TGD_PLZD<<YEAR>> cascade constraints;
Drop Table TMR_DRAFT<<YEAR>> cascade constraints;
Drop Table TMR_DRAFTASSISTANT<<YEAR>> cascade constraints;
Drop Table TMR_OFFSET<<YEAR>> cascade constraints;
Drop Table TMR_OFFSETDATA<<YEAR>> cascade constraints;
Drop Table TMR_OFFSETEQUAL<<YEAR>> cascade constraints;
Drop Table TMR_OFFSETITEM<<YEAR>> cascade constraints;
Drop Table TMR_OFFSETSUB<<YEAR>> cascade constraints;
Drop Table TMR_REPORT<<YEAR>> cascade constraints;
Drop Table TMR_REPORTDATA<<YEAR>> cascade constraints;
Drop Table TMR_TEMPLETDETAIL<<YEAR>> cascade constraints;
Drop Table TMR_TEMPLETMAIN<<YEAR>> cascade constraints;
Drop Table TUSU_DEPARTMENT<<YEAR>> cascade constraints;
Drop Table TUSU_FZ<<YEAR>> cascade constraints;
Drop Table TUSU_KMTOXMCLASS<<YEAR>> cascade constraints;
Drop Table TYSYF_BADACCOUNTKM<<YEAR>> cascade constraints;
Drop Table TYSYF_FZ<<YEAR>> cascade constraints;
Drop Table TYSYF_PZSJ<<YEAR>> cascade constraints;
Drop Table TZW_ACCOUNTAGE<<YEAR>> cascade constraints;
Drop Table TZW_BADACCOUNTAGE<<YEAR>> cascade constraints;
Drop Table TZW_BALANCE<<YEAR>> cascade constraints;
Drop Table TZW_BUDGET<<YEAR>> cascade constraints;
Drop Table TZW_BUDGETCONTROL<<YEAR>> cascade constraints;
Drop Table TZW_CHECK<<YEAR>> cascade constraints;
Drop Table TZW_CUSTOMER<<YEAR>> cascade constraints;
Drop Table TZW_CUSTOMERCLASS<<YEAR>> cascade constraints;
Drop Table TZW_CUSTOMERSHOWSET<<YEAR>> cascade constraints;
Drop Table TZW_EXCH<<YEAR>> cascade constraints;
Drop Table TZW_FOREIGNCURRENCY<<YEAR>> cascade constraints;
Drop Table TZW_IGENERALDATA<<YEAR>> cascade constraints;
Drop Table TZW_IGENERALSTRUCT<<YEAR>> cascade constraints;
Drop Table TZW_ITEM<<YEAR>> cascade constraints;
Drop Table TZW_ITEMCLASS<<YEAR>> cascade constraints;
Drop Table TZW_JSFS<<YEAR>> cascade constraints;
Drop Table TZW_KM<<YEAR>> cascade constraints;
Drop Table TZW_PLAN<<YEAR>> cascade constraints;
Drop Table TZW_PLUS<<YEAR>> cascade constraints;
Drop Table TZW_PZSJ<<YEAR>> cascade constraints;
Drop Table TZW_TEMPLETDETAIL<<YEAR>> cascade constraints;
Drop Table TZW_TEMPLETMAIN<<YEAR>> cascade constraints;
Drop Table TZW_TYPE<<YEAR>> cascade constraints;
Drop Table TZW_VENDOR<<YEAR>> cascade constraints;
Drop Table TZW_VENDORCLASS<<YEAR>> cascade constraints;
Drop Table TZW_VENDORSHOWSET<<YEAR>> cascade constraints;
Drop Table TZW_YHDZD<<YEAR>> cascade constraints;
Drop Table TZW_ZZHDSET<<YEAR>> cascade constraints;
Drop Table TZW_ZZPZSET<<YEAR>> cascade constraints;
DROP sequence S_OFFSETITEM<<YEAR>>_ID;
DROP sequence S_OFFSETEQUAL<<YEAR>>_ID;
DROP sequence S_OFFSETDRAFT<<YEAR>>_ID;
DROP sequence S_OFFSETDATA<<YEAR>>_ID;
DROP sequence S_OFFSETASSISTANT<<YEAR>>_ID;
DROP sequence S_OFFSET<<YEAR>>_ID;