清除数据库所有数据.sql

即时通讯

/*清除数据库记录脚本*/
delete from backgoods                -- 采购退货
delete from backgoodsdetail
delete from bom
delete from bomdetail
delete from bomprocess
delete from checkoption
delete from checkoptiongroup
delete from checkoptiongroupdetail
delete from checkrecord
delete from checkrecordvalue
delete from checkstandard
delete from checkvalue
delete from checkvaluegroup
delete from checkvaluegroupdetail
delete from cooperate
delete from cooperatecounterclaim
delete from cooperatedeatil
delete from cooperatedrawmaterial
delete from cooperatefinish
delete from cooperateredo
delete from CooperateFinishCheckRecord
delete from customer
delete from  department
delete from departmentdetail
delete from goods
delete from gyslb
delete from imagelist
delete from khdj
delete from khly
delete from lxfs
delete from lxmd
delete from part
delete from position
delete from produce
delete from producedeatil
delete from ProduceDraw
delete from producedrawmaterial
delete from producefinish
delete from producescheme
delete from production
delete from productype
delete from ps_bom
delete from ps_bomdetail
delete from ps_material
delete from relation
delete from schemebomdetail
delete from stockorder
delete from stockorderdetail
delete from stockstore
delete from stockstoredetail
delete from superinrtendent
delete from suppliertrouk
delete from testtable
delete from warehouse
delete from PartCheckMethod