title: Case Sensitive column names in Sql Azure Database
body: <p>Forever I've used a case sensitive collation in Sql Server (SQL_Latin1_General_CP1_CS_AS). I'm trying to move to Sql Azure Database and I've run into an unexpected problem. It looks like it's impossible to have case sensitive column names. Can this be true? </p>
  
  <p>I create my database...</p>
  
  <pre><code>CREATE DATABASE MyDatabase
  COLLATE SQL_Latin1_General_CP1_CS_AS
  </code></pre>
  
  <p>And I create my table...</p>
  
  <pre><code>CREATE TABLE [MyTable]
  (
      [Name] NVarChar (4000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
      [name] NVarChar (4000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL                                                                                
  )
  </code></pre>
  
  <p>And I get the error:
  Column names in each table must be unique. Column name 'name' in table 'MyTable' is specified more than once.</p>
  
  <p>Ugh, disaster. This works perfectly in Sql Server 2012. However on Sql Azure I can't seem to make it happen. Does anyone know why this is not working in Sql Azure? Does anyone know how I can make this work in Sql Azure? Thanks.</p>