title: The identity column must be of data type int, bigint, smallint, tinyint, decimal, or numeric
body: <p>I have created a database project in Visual Studio 2012, with target platform set to 'Windows Azure SQL Database'. I added a table like:</p>
  
  <pre><code>CREATE TABLE [dbo].[Organization]
  (
      [Id] UNIQUEIDENTIFIER NOT NULL PRIMARY KEY NONCLUSTERED IDENTITY, 
      [Name] NVARCHAR(100) NOT NULL, 
      [CreationDate] DATETIME NOT NULL DEFAULT GetDate()
  )
  
  GO
  
  CREATE CLUSTERED INDEX [IX_Organization_CreationDate] ON [dbo].[Organization] ([CreationDate])
  </code></pre>
  
  <p>But it keeps complaining about:</p>
  
  <pre><code>Error   1   SQL71518: The identity column '[dbo].[Organization].[Id]' must be of data type int, bigint, smallint, tinyint, decimal, or numeric with a scale of 0, and the column must not be nullable.  C:\Projects\Gastrology\MGP\trunk\Sources\Cfg.Mgp.Infrastructure.Database\Organization.sql   3   2   Cfg.Mgp.Infrastructure.Database
  </code></pre>
  
  <p>Anyone knows why I can't create a primary key of type guid? What Am I doing wrong?</p>
  
  <p>Thanks!</p>