title: Generating update script in Visual Studio 2010 Premium using Schema Compare is dropping tables, rather then altering?
body: <p>I'm using Visual Studio 2010 Premium's Schema Compare function, to compare two databases.</p>
  
  <p>I have added columns, altered some columns and changed stored procedures. Visual Studio is picking the changes up fine, when I drill down into each table, the Update Action for existing tables is set to 'Update', and the Update Action for the new columns it set to 'Create'.</p>
  
  <p>When I generate the update script it's actually dropping the tables, before creating them again.</p>
  
  <p>How can I generate an update script that just alters the existing table?</p>