Mandatory primary keys in Sql Azure

2018-07-02 08:49:01

I have been told that in SQL Azure that primary keys are mandatory on each table. However, I've been unable to find anything to back this up.

There are a number of references to mandatory clustered indexes, for example...

http://blogs.msdn.com/b/sqlazure/archive/2010/05/12/10011257.aspx

...but this article is from 2010, so I'm not sure if this is even relevant any more.

Can anyone tell me if primary keys are mandatory in each table in Sql Azure databases?

A primary key is not required. Clustered index - yes.

With Azure SQL Database V12 it is not mandatory anymore to have a clustered index.

See also http://sqlmag.com/sql-server/indexes-azure-sql-database-v12.

链接地址: http://www.djcxy.com/p/90228.html