pb+sql2000现代流通企业综合管理系统

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[库存结转表_VIEW]') and OBJECTPROPERTY(id, N'IsView') = 1) drop view [dbo].[库存结转表_VIEW] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[库存表_VIEW]') and OBJECTPROPERTY(id, N'IsView') = 1) drop view [dbo].[库存表_VIEW] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[pbcatcol]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[pbcatcol] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[pbcatedt]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[pbcatedt] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[pbcatfmt]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[pbcatfmt] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[pbcattbl]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[pbcattbl] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[pbcatvld]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[pbcatvld] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[供应商基础信息表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[供应商基础信息表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[供应商基础信息表备份]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[供应商基础信息表备份] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[供应商明细表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[供应商明细表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[供应商明细表备份]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[供应商明细表备份] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[入库票号表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[入库票号表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[入库票号表备份]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[入库票号表备份] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[入库结转表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[入库结转表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[入库结转表备份]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[入库结转表备份] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[入库表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[入库表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[入库表备份]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[入库表备份] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[入库退单票号表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[入库退单票号表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[入库退单票号表备份]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[入库退单票号表备份] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[入库退单结转表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[入库退单结转表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[入库退单结转表备份]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[入库退单结转表备份] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[入库退单表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[入库退单表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[入库退单表备份]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[入库退单表备份] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[员工基础信息表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[员工基础信息表] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[员工基础信息表备份]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[员工基础信息表备份] GO �