title: SQl Azure Switching Clusterd and Non Clustered Index
body: <p>I have two indexes on my table:</p>
  
  <pre><code>CREATE CLUSTERED INDEX [IXAddrbookCrtDtm] ON [dbo].[Addrbook]
  (
       [AbkOrgGrpID] ASC,
       [AddrbookID] ASC
  )
  WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,
        SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF,
        ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
  GO
  </code></pre>
  
  <p>and</p>
  
  <pre><code>ALTER TABLE [dbo].[Addrbook]
      ADD CONSTRAINT [PKAddrbook_New]
        PRIMARY KEY NONCLUSTERED 
        (
         [AbkOrgGrpID] ASC,
         [AddrbookID] ASC
        )
        WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,
              SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, 
              ONLINE = OFF, ALLOW_ROW_LOCKS = ON,
             ALLOW_PAGE_LOCKS = ON)
  GO
  </code></pre>
  
  <p>I need to have just one Clustered Primary Key Index instead of above two. Dropping and recreating the tables is not an option.</p>
  
  <p>Is there something like</p>
  
  <pre><code>CREATE CLUSTERED INDEX IXAddrbookCrtDtm ON
      Addrbook(AbkOrgGrpID,AddrbookID)
      PRIMARY KEY  WITH (DROP_EXISTING = ON);
  </code></pre>
  
  <p>so that I can then drop the non-clustered index?</p>