drop view OrderPayDelView
drop view favoriteView
drop view oosProduct_view
drop view orderProductsView
drop view returnProductView
drop view shippingProductView
drop view account_view
drop view admin_view
drop view blogAndCateView
drop view membLeveInfo_view
drop view proBraCatManView
drop view productAndImgView
drop view productAndTagView
drop view returnBillView
drop view roleAndPowerView
drop view shippingBillView
drop table shop_account
drop table shop_addressBook
drop table shop_admin
drop table shop_adminLog
drop table shop_adminMenu
drop table shop_blogCate
drop table shop_blogInTag
drop table shop_blogs
drop table shop_blogTag
drop table shop_brand
drop table shop_cartProducts
drop table shop_comment
drop table shop_currencyList
drop table shop_customPage
drop table shop_deliveryCompany
drop table shop_deliveryFee
drop table shop_deliveryManager
drop table shop_emailQueue
drop table shop_emailTemplate
drop table shop_errorNullPage
drop table shop_expressBill
drop table shop_expressBillPosition
drop table shop_favorite
drop table shop_flash
drop table shop_grabReg
drop table shop_guestBook
drop table shop_helperArticle
drop table shop_hotWord
drop table shop_IPCategory
drop table shop_Links
drop table shop_listShow
drop table shop_manufacturer
drop table shop_memberInfo
drop table shop_memberIntegral
drop table shop_memberLevel
drop table shop_onlineServer
drop table shop_onlineTemplate
drop table shop_oosBook
drop table shop_orderLog
drop table shop_orderNote
drop table shop_orderProducts
drop table shop_orderTag
drop table shop_order
drop table shop_payLog
drop table shop_payment
drop table shop_payNotify
drop table shop_power
drop table shop_productCate
drop table shop_productColor
drop table shop_productInCategory
drop table shop_productInTag
drop table shop_productsImg
drop table shop_productSize
drop table shop_productTag
drop table shop_receiptBill
drop table shop_refundBill
drop table shop_registPage
drop table shop_relaCombination
drop table shop_relaFittings
drop table shop_relaProducts
drop table shop_returnProduct
drop table shop_returnBill
drop table shop_rolePower
drop table shop_senderInfo
drop table shop_shippingProduct
drop table shop_shippingBill
drop table shop_siteBaseInfo
drop table shop_siteImageSet
drop table shop_siteMessage
drop table shop_siteNotice
drop table shop_siteSEO
drop table shop_siteSubject
drop table shop_siteTemplates
drop table shop_SmsQueue
drop table shop_smsSet
drop table shop_smtpSet
drop table shop_subscribe
drop table shop_voucher
drop table shop_webLayout
drop table shop_adminRole
drop table shop_products
drop table shop_member
execute sp_droptype dm_Bool
execute sp_droptype dm_address
execute sp_droptype dm_articleType
execute sp_droptype dm_billID
execute sp_droptype dm_blogID
execute sp_droptype dm_categoryID
execute sp_droptype dm_categoryName
execute sp_droptype dm_city
execute sp_droptype dm_country
execute sp_droptype dm_date
execute sp_droptype dm_deliverID
execute sp_droptype dm_departmentID
execute sp_droptype dm_email
execute sp_droptype dm_expressID
execute sp_droptype dm_goodID
execute sp_droptype dm_imgUrl
execute sp_droptype dm_ip
execute sp_droptype dm_ipLocation
execute sp_droptype dm_linkUrl
execute sp_droptype dm_memberID
execute sp_droptype dm_menuID
execute sp_droptype dm_menuName
execute sp_droptype dm_mobi
execute sp_droptype dm_msgContent
execute sp_droptype dm_msgID
execute sp_droptype dm_msgTitle
execute sp_droptype dm_name
execute sp_droptype dm_orderID
execute sp_droptype dm_orderIndex
execute sp_droptype dm_paymentID
execute sp_droptype dm_permissionID
execute sp_droptype dm_productName
execute sp_droptype dm_providerID
execute sp_droptype dm_providerName
execute sp_droptype dm_province
execute sp_droptype dm_pwd
execute sp_droptype dm_quantity
execute sp_droptype dm_remark
execute sp_droptype dm_roleID
execute sp_droptype dm_sum
execute sp_droptype dm_tagID
execute sp_droptype dm_tel
execute sp_droptype dm_templateName
execute sp_droptype dm_txDate
execute sp_droptype dm_voucherID
execute sp_droptype dm_zip