title: What is the c# SMO way to create an Azure ClusteredColumnStoreIndex for a P1 SQL database
body: <p>Using a SQL Azure P1 Premium, V12 in North Europe, I can do this:</p>
  
  <pre><code>CREATE CLUSTERED COLUMNSTORE INDEX cci_Simple ON SimpleTable;
  </code></pre>
  
  <p>but not this: (using Microsoft.SqlServer.SqlEnum, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91)</p>
  
  <pre><code>var t = new Table(db, "SimpleTable");
  // ... Add Columns
  t.Create()
  var index = new Index(t, "cci_" + t.Name)
  {
       IndexType = IndexType.ClusteredColumnStoreIndex,
  };
  index.Create();
  </code></pre>
  
  <p>I get:</p>
  
  <pre><code>Microsoft.SqlServer.Management.Smo.FailedOperationExceptionCreate failed for Index 'cci_SimpleTable'. 
  at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl()
  at Microsoft.SqlServer.Management.Smo.Index.Create()
  at ...
  Microsoft.SqlServer.Management.Smo.UnsupportedEngineTypeException
  </code></pre>
  
  <p>Either the object or one of its properties is not supported on the target engine type.</p>
  
  <p>References;</p>
  
  <p><a href="https://msdn.microsoft.com/library/gg492153.aspx" rel="nofollow">https://msdn.microsoft.com/library/gg492153.aspx</a></p>
  
  <p><a href="http://www.nikoport.com/2014/12/12/azure-columnstore-1-the-initial-preview-offering/" rel="nofollow">http://www.nikoport.com/2014/12/12/azure-columnstore-1-the-initial-preview-offering/</a></p>