1

Possible Duplicate:
How can I alter an existing Primary Key on SQL Azure?

OK, so say I have a table: 'Contact' and a primary key: 'ContactID'.

The primary key is an INT but I want to change it to a BIGINT.

In order to do this, I have to drop the primary key constraint.

In order to drop the constraint, I have to remove the clustered index.

But SQL Azure requires a clustered index on all tables at all times, so in order to remove the clustered index, I have to add another one on another field.

The problem is, I can't have more than one clustered index in a table.

So it seems like a catch-22: I can't remove the clustered index because there must be at least one, but I can't create another clustered index because there cannot be more than one.

So is it possible at all to change the data-type of a column in SQL Azure?

marked as duplicate by jcolebrand Dec 31 '11 at 6:38

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.