📄 hms2000.sql
字号:
go
if exists (select 1
from sysobjects
where id = object_id('DBA.rtyy')
and type = 'U')
drop table DBA.rtyy
go
if exists (select 1
from sysobjects
where id = object_id('DBA.sbox')
and type = 'U')
drop table DBA.sbox
go
if exists (select 1
from sysobjects
where id = object_id('DBA.sfz')
and type = 'U')
drop table DBA.sfz
go
if exists (select 1
from sysobjects
where id = object_id('DBA.shft')
and type = 'U')
drop table DBA.shft
go
if exists (select 1
from sysobjects
where id = object_id('DBA.sqd')
and type = 'U')
drop table DBA.sqd
go
if exists (select 1
from sysobjects
where id = object_id('DBA.swdx_wzdm')
and type = 'U')
drop table DBA.swdx_wzdm
go
if exists (select 1
from sysobjects
where id = object_id('DBA.sy_wbdh')
and type = 'U')
drop table DBA.sy_wbdh
go
if exists (select 1
from sysobjects
where id = object_id('DBA.sys_txsm')
and type = 'U')
drop table DBA.sys_txsm
go
if exists (select 1
from sysobjects
where id = object_id('DBA.syssrg')
and type = 'U')
drop table DBA.syssrg
go
if exists (select 1
from sysobjects
where id = object_id('DBA.ta_cfg')
and type = 'U')
drop table DBA.ta_cfg
go
if exists (select 1
from sysobjects
where id = object_id('DBA.tbzh')
and type = 'U')
drop table DBA.tbzh
go
if exists (select 1
from sysobjects
where id = object_id('DBA.tfxx')
and type = 'U')
drop table DBA.tfxx
go
if exists (select 1
from sysobjects
where id = object_id('DBA.tjkm')
and type = 'U')
drop table DBA.tjkm
go
if exists (select 1
from sysobjects
where id = object_id('DBA.tjmd')
and type = 'U')
drop table DBA.tjmd
go
if exists (select 1
from sysobjects
where id = object_id('DBA.tlsy')
and type = 'U')
drop table DBA.tlsy
go
if exists (select 1
from sysobjects
where id = object_id('DBA.ttzh')
and type = 'U')
drop table DBA.ttzh
go
if exists (select 1
from sysobjects
where id = object_id('DBA.type')
and type = 'U')
drop table DBA.type
go
if exists (select 1
from sysobjects
where id = object_id('DBA.wcal')
and type = 'U')
drop table DBA.wcal
go
if exists (select 1
from sysobjects
where id = object_id('DBA.wz_bm')
and type = 'U')
drop table DBA.wz_bm
go
if exists (select 1
from sysobjects
where id = object_id('DBA.wz_db')
and type = 'U')
drop table DBA.wz_db
go
if exists (select 1
from sysobjects
where id = object_id('DBA.wz_dbmx')
and type = 'U')
drop table DBA.wz_dbmx
go
if exists (select 1
from sysobjects
where id = object_id('DBA.wz_jhdw')
and type = 'U')
drop table DBA.wz_jhdw
go
if exists (select 1
from sysobjects
where id = object_id('DBA.wzbs')
and type = 'U')
drop table DBA.wzbs
go
if exists (select 1
from sysobjects
where id = object_id('DBA.wzbsmx')
and type = 'U')
drop table DBA.wzbsmx
go
if exists (select 1
from sysobjects
where id = object_id('DBA.wzbspzr')
and type = 'U')
drop table DBA.wzbspzr
go
if exists (select 1
from sysobjects
where id = object_id('DBA.wzck')
and type = 'U')
drop table DBA.wzck
go
if exists (select 1
from sysobjects
where id = object_id('DBA.wzckmx')
and type = 'U')
drop table DBA.wzckmx
go
if exists (select 1
from sysobjects
where id = object_id('DBA.wzdm')
and type = 'U')
drop table DBA.wzdm
go
if exists (select 1
from sysobjects
where id = object_id('DBA.wzfl')
and type = 'U')
drop table DBA.wzfl
go
if exists (select 1
from sysobjects
where id = object_id('DBA.wzkc')
and type = 'U')
drop table DBA.wzkc
go
if exists (select 1
from sysobjects
where id = object_id('DBA.wzmm')
and type = 'U')
drop table DBA.wzmm
go
if exists (select 1
from sysobjects
where id = object_id('DBA.wzpd')
and type = 'U')
drop table DBA.wzpd
go
if exists (select 1
from sysobjects
where id = object_id('DBA.wzqx')
and type = 'U')
drop table DBA.wzqx
go
if exists (select 1
from sysobjects
where id = object_id('DBA.wzrk')
and type = 'U')
drop table DBA.wzrk
go
if exists (select 1
from sysobjects
where id = object_id('DBA.wzrkmz')
and type = 'U')
drop table DBA.wzrkmz
go
if exists (select 1
from sysobjects
where id = object_id('DBA.wzzc')
and type = 'U')
drop table DBA.wzzc
go
if exists (select 1
from sysobjects
where id = object_id('DBA.xfjl5')
and type = 'U')
drop table DBA.xfjl5
go
if exists (select 1
from sysobjects
where id = object_id('DBA.xszx_sheet1')
and type = 'U')
drop table DBA.xszx_sheet1
go
if exists (select 1
from sysobjects
where id = object_id('DBA.xszx_sheet2')
and type = 'U')
drop table DBA.xszx_sheet2
go
if exists (select 1
from sysobjects
where id = object_id('DBA.xt')
and type = 'U')
drop table DBA.xt
go
if exists (select 1
from sysobjects
where id = object_id('DBA.xt_dj')
and type = 'U')
drop table DBA.xt_dj
go
if exists (select 1
from sysobjects
where id = object_id('DBA.xt_dz')
and type = 'U')
drop table DBA.xt_dz
go
if exists (select 1
from sysobjects
where id = object_id('DBA.xt_log')
and type = 'U')
drop table DBA.xt_log
go
if exists (select 1
from sysobjects
where id = object_id('DBA.xt_mk')
and type = 'U')
drop table DBA.xt_mk
go
if exists (select 1
from sysobjects
where id = object_id('DBA.xt_zd')
and type = 'U')
drop table DBA.xt_zd
go
if exists (select 1
from sysobjects
where id = object_id('DBA.xtzc')
and type = 'U')
drop table DBA.xtzc
go
if exists (select 1
from sysobjects
where id = object_id('DBA.xxzx0')
and type = 'U')
drop table DBA.xxzx0
go
if exists (select 1
from sysobjects
where id = object_id('DBA.xxzx1')
and type = 'U')
drop table DBA.xxzx1
go
if exists (select 1
from sysobjects
where id = object_id('DBA.xxzx10')
and type = 'U')
drop table DBA.xxzx10
go
if exists (select 1
from sysobjects
where id = object_id('DBA.xxzx11')
and type = 'U')
drop table DBA.xxzx11
go
if exists (select 1
from sysobjects
where id = object_id('DBA.xxzx2')
and type = 'U')
drop table DBA.xxzx2
go
if exists (select 1
from sysobjects
where id = object_id('DBA.xxzx3')
and type = 'U')
drop table DBA.xxzx3
go
if exists (select 1
from sysobjects
where id = object_id('DBA.xxzx4')
and type = 'U')
drop table DBA.xxzx4
go
if exists (select 1
from sysobjects
where id = object_id('DBA.xxzx5')
and type = 'U')
drop table DBA.xxzx5
go
if exists (select 1
from sysobjects
where id = object_id('DBA.xxzx6')
and type = 'U')
drop table DBA.xxzx6
go
if exists (select 1
from sysobjects
where id = object_id('DBA.xxzx7')
and type = 'U')
drop table DBA.xxzx7
go
if exists (select 1
from sysobjects
where id = object_id('DBA.xyk')
and type = 'U')
drop table DBA.xyk
go
if exists (select 1
from sysobjects
where id = object_id('DBA.yd_hys')
and type = 'U')
drop table DBA.yd_hys
go
if exists (select 1
from sysobjects
where id = object_id('DBA.yd_ttpf')
and type = 'U')
drop table DBA.yd_ttpf
go
if exists (select 1
from sysobjects
where id = object_id('DBA.ydd')
and type = 'U')
drop table DBA.ydd
go
if exists (select 1
from sysobjects
where id = object_id('DBA.ydpf')
and type = 'U')
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -