CODEWITHSUNDEEP
sqlazureprimary-keyclustered-index
Gais
Gais

Reputation: 575

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?

Upvotes: 1

Views: 1622

Answers (2)

Tobias
Tobias

Reputation: 2139

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

See also https://www.itprotoday.com/sql-server/indexes-azure-sql-database-v12.

Upvotes: 2

mcollier
mcollier

Reputation: 3719

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

Upvotes: 1

Related Questions