No3:
========================================创建表===================================
CREATE TABLE [dbo].[Customer_1] (
[CustomerID] [int] NOT NULL ,
[CusName] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Customer_2] (
[CustomerID] [int] NOT NULL ,
[CusName] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Customer_3] (
[CustomerID] [int] NOT NULL ,
[CusName] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
========================================创建约束=================================
ALTER TABLE [dbo].[Customer_1] WITH NOCHECK ADD
CONSTRAINT [PK_Customer_1] PRIMARY KEY CLUSTERED
(
[CustomerID]
) ON [PRIMARY] ,
CONSTRAINT [CK__Customer___Custo__35BCFE0A] CHECK ([CustomerID] >= 1 and [CustomerID] <= 1000)
GO
ALTER TABLE [dbo].[Customer_2] WITH NOCHECK ADD
CONSTRAINT [PK_Customer_2] PRIMARY KEY CLUSTERED
(
[CustomerID]
) ON [PRIMARY] ,
CONSTRAINT [CK__Customer___Custo__37A5467C] CHECK ([CustomerID] >= 1001 and [CustomerID] <= 2000)
GO
ALTER TABLE [dbo].[Customer_3] WITH NOCHECK ADD
CONSTRAINT [PK_Customer_3] PRIMARY KEY CLUSTERED
(
[CustomerID]
) ON [PRIMARY] ,
CONSTRAINT [CK__Customer___Custo__398D8EEE] CHECK ([CustomerID] >= 2002 and [CustomerID] <= 5000)
GO
========================================创建视图=================================
SELECT *
FROM Customer_1
UNION ALL
SELECT *
FROM Customer_2
UNION ALL
SELECT *
FROM Customer_3
以上完成分区视图的创建
为什么执行
insert into Customer values(1,'abc')出错:UNION ALL 视图 'Customer' 不可更新,因为没有找到分区列。