drop view [dbo].[productAndImgView]
drop view [dbo].[favoriteView]
drop view [dbo].[roleAndPowerView]
drop view [dbo].[OrderPayDelView]
drop view [dbo].[account_view]
drop view [dbo].[admin_view]
drop view [dbo].[blogAndCateView]
drop view [dbo].[membLeveInfo_view]
drop view [dbo].[oosProduct_view]
drop view [dbo].[orderProductsView]
drop view [dbo].[proBraCatManView]
drop view [dbo].[productAndTagView]
drop view [dbo].[returnBillView]
drop view [dbo].[returnProductView]
drop view [dbo].[shippingBillView]
drop view [dbo].[shippingProductView]
drop table dbo.shop_IPCategory
drop table dbo.shop_Links
drop table dbo.shop_SmsQueue
drop table dbo.shop_account
drop table dbo.shop_addressBook
drop table dbo.shop_admin
drop table dbo.shop_adminLog
drop table dbo.shop_adminMenu
drop table dbo.shop_adminRole
drop table dbo.shop_blogCate
drop table dbo.shop_blogInTag
drop table dbo.shop_blogTag
drop table dbo.shop_blogs
drop table dbo.shop_brand
drop table dbo.shop_cartProducts
drop table dbo.shop_comment
drop table dbo.shop_currencyList
drop table dbo.shop_customPage
drop table dbo.shop_deliveryCompany
drop table dbo.shop_deliveryFee
drop table dbo.shop_deliveryManager
drop table dbo.shop_emailQueue
drop table dbo.shop_emailTemplate
drop table dbo.shop_errorNullPage
drop table dbo.shop_expressBill
drop table dbo.shop_expressBillPosition
drop table dbo.shop_favorite
drop table dbo.shop_flash
drop table dbo.shop_guestBook
drop table dbo.shop_helperArticle
drop table dbo.shop_hotWord
drop table dbo.shop_listShow
drop table dbo.shop_manufacturer
drop table dbo.shop_member
drop table dbo.shop_memberInfo
drop table dbo.shop_memberIntegral
drop table dbo.shop_memberLevel
drop table dbo.shop_onlineServer
drop table dbo.shop_oosBook
drop table dbo.shop_order
drop table dbo.shop_orderLog
drop table dbo.shop_orderProducts
drop table dbo.shop_orderTag
drop table dbo.shop_payLog
drop table dbo.shop_payNotify
drop table dbo.shop_payment
drop table dbo.shop_power
drop table dbo.shop_productCate
drop table dbo.shop_productColor
drop table dbo.shop_productInCategory
drop table dbo.shop_productInTag
drop table dbo.shop_productSize
drop table dbo.shop_productTag
drop table dbo.shop_products
drop table dbo.shop_productsImg
drop table dbo.shop_receiptBill
drop table dbo.shop_refundBill
drop table dbo.shop_relaCombination
drop table dbo.shop_relaFittings
drop table dbo.shop_relaProducts
drop table dbo.shop_returnBill
drop table dbo.shop_returnProduct
drop table dbo.shop_rolePower
drop table dbo.shop_senderInfo
drop table dbo.shop_shippingBill
drop table dbo.shop_shippingProduct
drop table dbo.shop_siteBaseInfo
drop table dbo.shop_siteImageSet
drop table dbo.shop_siteMessage
drop table dbo.shop_siteNotice
drop table dbo.shop_siteSEO
drop table dbo.shop_siteSubject
drop table dbo.shop_siteTemplates
drop table dbo.shop_smsSet
drop table dbo.shop_smtpSet
drop table dbo.shop_voucher
drop table dbo.shop_webLayout
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