如何在VS 2013中构建SQL Azure数据库项目在每个表上都没有聚簇索引。 [英] How to Build SQL Azure database Project in VS 2013 Without a clustered index on every table.

问题描述

我们有一个SQL Azure数据库项目，我们在每个表上都有PRIMARY KEY CLUSTERED。使用此解决方案正确构建。



但是当我们从表中删除PRIMARY KEY CLUSTERED时，构建失败并出现以下错误错误200 SQL71560：表[dbo]。[ abc]没有聚簇索引。在此版本的SQL Server中插入数据需要聚簇索引

we have a SQL Azure database project, we have PRIMARY KEY CLUSTERED on each table. solution builds properly with this.

but when we remove PRIMARY KEY CLUSTERED from the table , build is failed with following error "Error 200 SQL71560: Table [dbo].[abc] does not have a clustered index. Clustered indexes are required for inserting data in this version of SQL Server"

推荐答案

引用：

SQL Azure每个表至少需要一个聚簇索引，以便维护为所有数据库开箱即用的其他两个副本。您可以创建没有聚簇索引的表，但是如果您尝试执行任何CRUD操作，则会抛出此错误。

SQL Azure needs at least one clustered index per table in order to maintain the other two replicas that are created out of the box for all databases. You can create a table without the clustered index, but if you try to do any CRUD operation this error will be thrown.

来自 dnnsoftware [ ^ ]



因此请将聚簇索引保留在那里，或找到Azure的替代方法

from dnnsoftware[^]

So leave the clustered indexes on there, or find an alternative to Azure

这篇关于如何在VS 2013中构建SQL Azure数据库项目在每个表上都没有聚簇索引。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！