/****** Object: Database 进销存 Script Date: 2001-8-9 13:57:40 ******/
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'进销存')
DROP DATABASE [进销存]
GO
CREATE DATABASE [进销存] ON (NAME = N'进销存_Data', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL\data\进销存_Data.mdf' , SIZE = 6, FILEGROWTH = 10%) LOG ON (NAME = N'进销存_Log', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL\data\进销存_Log.ldf' , SIZE = 1, FILEGROWTH = 10%)
GO
exec sp_dboption N'进销存', N'autoclose', N'false'
GO
exec sp_dboption N'进销存', N'bulkcopy', N'false'
GO
exec sp_dboption N'进销存', N'trunc. log', N'false'
GO
exec sp_dboption N'进销存', N'torn page detection', N'true'
GO
exec sp_dboption N'进销存', N'read only', N'false'
GO
exec sp_dboption N'进销存', N'dbo use', N'false'
GO
exec sp_dboption N'进销存', N'single', N'false'
GO
exec sp_dboption N'进销存', N'autoshrink', N'false'
GO
exec sp_dboption N'进销存', N'ANSI null default', N'false'
GO
exec sp_dboption N'进销存', N'recursive triggers', N'false'
GO
exec sp_dboption N'进销存', N'ANSI nulls', N'false'
GO
exec sp_dboption N'进销存', N'concat null yields null', N'false'
GO
exec sp_dboption N'进销存', N'cursor close on commit', N'false'
GO
exec sp_dboption N'进销存', N'default to local cursor', N'false'
GO
exec sp_dboption N'进销存', N'quoted identifier', N'false'
GO
exec sp_dboption N'进销存', N'ANSI warnings', N'false'
GO
exec sp_dboption N'进销存', N'auto create statistics', N'true'
GO
exec sp_dboption N'进销存', N'auto update statistics', N'true'
GO
use [进销存]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_采购单主表_仓库主文件]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[采购单主表] DROP CONSTRAINT FK_采购单主表_仓库主文件
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_采购入库单明细表_仓库主文件]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[采购入库单明细表] DROP CONSTRAINT FK_采购入库单明细表_仓库主文件
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_仓库与物料_仓库主文件]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[仓库与物料] DROP CONSTRAINT FK_仓库与物料_仓库主文件
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_其他出库_仓库主文件]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[出库] DROP CONSTRAINT FK_其他出库_仓库主文件
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_库存参数表_仓库主文件]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[库存参数表] DROP CONSTRAINT FK_库存参数表_仓库主文件
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_库存调整_仓库主文件]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[库存调整] DROP CONSTRAINT FK_库存调整_仓库主文件
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_实地盘点数据表_仓库主文件]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[实地盘点数据表] DROP CONSTRAINT FK_实地盘点数据表_仓库主文件
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_物料与货位对照表_仓库主文件]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[物料与货位对照表] DROP CONSTRAINT FK_物料与货位对照表_仓库主文件
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_销售出库单明细表_仓库主文件]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[销售出库单明细表] DROP CONSTRAINT FK_销售出库单明细表_仓库主文件
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_销售单_基本_仓库主文件]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[销售单主表] DROP CONSTRAINT FK_销售单_基本_仓库主文件
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_供应商主文件_付款暂停码]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[供应商主文件] DROP CONSTRAINT FK_供应商主文件_付款暂停码
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_客户主文件_信用暂停表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[客户主文件] DROP CONSTRAINT FK_客户主文件_信用暂停表
GO
if exists (select *�
评论0
最新资源