Search code examples
sqlazureprimary-keyclustered-index

Mandatory primary keys in Sql Azure

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?

Solution

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