title: How can we rename the primary key of a table in FluentMigrator?
body: <p>I need to rename the primary key of an existing table through <code>FluentMigrator</code> so an automapper can automatically detect the column.  </p>
  
  <p>For most columns, it's a simple <code>1)</code> delete any foreign key constraints on that column <code>2)</code> delete indices for that column and <code>3)</code> rename the column.  I have historically done this by:</p>
  
  <pre><code>Delete.ForeignKey("foreignkeyconstraint").OnTable("mytable");
  Delete.Index("UserId").OnTable("mytable");
  Rename.Column("UserId").OnTable("mytable").To("UserInfo_id");
  </code></pre>
  
  <p>However, this doesn't appear to work for primary keys, since I can't delete the automatically created index on that column.  What is the correct way to rename a primary key column with <code>FluentMigrator</code>?</p>