hms2000.sql

很好用的酒店管理软件

if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.krlb')
            and   type = 'U')
   drop table DBA.krlb
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.krzl')
            and   type = 'U')
   drop table DBA.krzl
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.kszl')
            and   type = 'U')
   drop table DBA.kszl
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.kszl_mx')
            and   type = 'U')
   drop table DBA.kszl_mx
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.ld')
            and   type = 'U')
   drop table DBA.ld
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.lqf')
            and   type = 'U')
   drop table DBA.lqf
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.lsb')
            and   type = 'U')
   drop table DBA.lsb
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.lsfd')
            and   type = 'U')
   drop table DBA.lsfd
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.mm')
            and   type = 'U')
   drop table DBA.mm
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.mrys')
            and   type = 'U')
   drop table DBA.mrys
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.mz')
            and   type = 'U')
   drop table DBA.mz
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.paj')
            and   type = 'U')
   drop table DBA.paj
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.pbcatcol')
            and   type = 'U')
   drop table DBA.pbcatcol
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.pbcatedt')
            and   type = 'U')
   drop table DBA.pbcatedt
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.pbcatfmt')
            and   type = 'U')
   drop table DBA.pbcatfmt
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.pbcattbl')
            and   type = 'U')
   drop table DBA.pbcattbl
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.pbcatvld')
            and   type = 'U')
   drop table DBA.pbcatvld
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.pct_fk')
            and   type = 'U')
   drop table DBA.pct_fk
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.pctdd')
            and   type = 'U')
   drop table DBA.pctdd
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.pctddcd')
            and   type = 'U')
   drop table DBA.pctddcd
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.pfjzh')
            and   type = 'U')
   drop table DBA.pfjzh
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.pgzzh')
            and   type = 'U')
   drop table DBA.pgzzh
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.pjzd')
            and   type = 'U')
   drop table DBA.pjzd
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.pkszl')
            and   type = 'U')
   drop table DBA.pkszl
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.price')
            and   type = 'U')
   drop table DBA.price
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.prjz')
            and   type = 'U')
   drop table DBA.prjz
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.ptbzh')
            and   type = 'U')
   drop table DBA.ptbzh
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.pttzh')
            and   type = 'U')
   drop table DBA.pttzh
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.pydd')
            and   type = 'U')
   drop table DBA.pydd
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.pydpf')
            and   type = 'U')
   drop table DBA.pydpf
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.pz_ss')
            and   type = 'U')
   drop table DBA.pz_ss
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.pz_ys')
            and   type = 'U')
   drop table DBA.pz_ys
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.pzd')
            and   type = 'U')
   drop table DBA.pzd
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.pzjb')
            and   type = 'U')
   drop table DBA.pzjb
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.pzkd')
            and   type = 'U')
   drop table DBA.pzkd
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.pzm')
            and   type = 'U')
   drop table DBA.pzm
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.pzr')
            and   type = 'U')
   drop table DBA.pzr
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.pzzd')
            and   type = 'U')
   drop table DBA.pzzd
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.qx')
            and   type = 'U')
   drop table DBA.qx
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.qxzm')
            and   type = 'U')
   drop table DBA.qxzm
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.qzzl')
            and   type = 'U')
   drop table DBA.qzzl
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.rjka')
            and   type = 'U')
   drop table DBA.rjka
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.rs_bm')
            and   type = 'U')
   drop table DBA.rs_bm
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.rs_da')
            and   type = 'U')
   drop table DBA.rs_da
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.rs_grjl')
            and   type = 'U')
   drop table DBA.rs_grjl
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.rs_gzjb')
            and   type = 'U')
   drop table DBA.rs_gzjb
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.rs_gzxm')
            and   type = 'U')
   drop table DBA.rs_gzxm
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.rs_gzzt')
            and   type = 'U')
   drop table DBA.rs_gzzt
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.rs_jchjl')
            and   type = 'U')
   drop table DBA.rs_jchjl
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.rs_jj')
            and   type = 'U')
   drop table DBA.rs_jj
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.rs_kqjl')
            and   type = 'U')
   drop table DBA.rs_kqjl
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.rs_lzjl')
            and   type = 'U')
   drop table DBA.rs_lzjl
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.rs_pds')
            and   type = 'U')
   drop table DBA.rs_pds
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.rs_px')
            and   type = 'U')
   drop table DBA.rs_px
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.rs_qs')
            and   type = 'U')
   drop table DBA.rs_qs
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.rs_rzjl')
            and   type = 'U')
   drop table DBA.rs_rzjl
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.rs_xl')
            and   type = 'U')
   drop table DBA.rs_xl
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.rs_ygdd')
            and   type = 'U')
   drop table DBA.rs_ygdd
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.rs_ygtz')
            and   type = 'U')
   drop table DBA.rs_ygtz
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.rs_zw')
            and   type = 'U')
   drop table DBA.rs_zw
go


if exists (select 1
            from  sysobjects
           where  id = object_id('DBA.rs_zzmm')
            and   type = 'U')
   drop table DBA.rs_zzmm