供暖空库语法

USE [heating]
GO

delete Area
delete Area_jc
delete Aspect
delete At23
delete baklcisnull
delete bank
delete bbb
delete bhcw
delete billid_qz
delete bm
delete boiler
delete Breakdown
delete builddd
delete Building
delete building_null
delete Building2
delete buildingnameisnull
delete buildingnameisnullnew
delete coal
delete coal_electricity
delete coal_in
delete coal_material
delete coal_other
delete coal_out
delete coal_rengong
delete coal_repair
delete coal_test
delete coal_water
delete coal_welfare
delete coal_year
delete coal_yearnum
delete collectmc
delete consignee
delete country
delete crop_report
delete cuwu
delete dealunit
delete doup
delete dyisnull
delete dyisnullbak
delete emp
delete EMPLOYEE where EMP_ID <> '000000'
delete ErrorTable
delete feesource
delete fhcfcf
delete fhisnullbak
delete fhxx
delete files
delete Filesname
delete gnsqd
delete gratisbill
delete gratisreason
delete gs
delete gspaydetail
delete gspaydetail2
delete gw
delete hbo
delete hstj
delete image
delete import
delete Index_Mention
delete insert_receipt
delete Instock
delete instock_main_qx where operatorid <> '000000'
delete itemp
delete jianmian
delete jjkk
delete kszzf
delete kzmxb
delete lcisnull
delete lhcw
delete liu2
delete liubl
delete liuhf
delete liujxy
delete liuqjyf
delete liuslj
delete liuxb
delete liuxx
delete liuxy
delete ljxq
delete model
delete Month
delete newsRoom
delete nullroom_date
delete nyzhl
delete oldowe
delete oldowe2
delete OperationDiary
delete Operator
delete operator_area where operatorid <> '000000'
delete operator_qx where operatorid <> '000000'
delete operatorid
delete opt_log
delete owereport
delete owereportmx
delete owereportmx2
delete owereportmx2011
delete owereportmxowner
delete owner
delete owner_Approval
delete owner_image
delete owner2
delete ownercard
delete ownercnt
delete ownerliu
delete ownerr
delete paydetail
delete paydetail_day
delete paydetail_hz
delete paydetail_ls
delete paydetail_lsjk
delete paydetail_zqt
delete paydetail2
delete paydetailbt
delete paydetailsum
delete paysum
delete pet
delete Popedom
delete propertyshift
delete protocol
delete punish
delete Purchase_d
delete Purchase_detail
delete pzhzb
delete pzhzb2
delete pzhzb3
delete receipt_lq
delete receipt_mx
delete receipt_rkmx
delete receipt_sh
delete RecvMsgTable
delete rep_ator
delete repair
delete rjlread
delete room
delete room_gl
delete Room2
delete roombak
delete Roombeifen
delete roombf
delete roomcj
delete roomidcnt
delete roomidtext_cf
delete roomname
delete roomnamenew
delete roomnameRoom
delete roomnull
delete roomtextcnt
delete roomxh
delete roomxw
delete sbdagl
delete sbfile
delete sbfldy
delete sbwxd
delete scsdy
delete Section
delete segment
delete SendMsgTable
delete sfsz
delete sfy
delete sfy_buildys2
delete sfyysb
delete shortcutdict
delete slycs
delete SMS
delete stock
delete SystemStatusTable
delete tcfactor
delete textcw
delete tgmx
delete tool
delete TReport
delete ts
delete type
delete unit
delete Uptown
delete Uptown2
delete wd_jc
delete wenti
delete year
delete yearnum
delete yearnum_znj
delete yearnumprice
delete yjje
delete zhcw