title: Changing size of db column from varchar50 to varchar255
body: <p>Inside <code>microsoft sql server</code> database I have table <code>User</code> with column <code>Password</code>. <code>Password</code> is of type <code>varchar(50)</code> and I want to change to <code>varchar(255)</code>.</p>
  
  <p>I tried using <code>microsoft sql server management studio</code> and using design view I tried manually to change 50 to 255 but on saving that action I'm getting alert </p>
  
  <blockquote>
    <p>Following tables will be saved to your database. Do you want to continue?</p>
  </blockquote>
  
  <pre><code>User
  xx
  xx
  xx
  </code></pre>
  
  <p>On chosing yes I'm waiting for whole min with mouse cursor busy and I'm getting back </p>
  
  <blockquote>
    <p>Errors were encountered during the save process. Some database objects were not saved.
    User table, Unable to delete relationship FK.....
    Timeout expired.</p>
  </blockquote>
  
  <p>I'm confused since I'm not changing anything but this lenght of Password column.</p>
  
  <p>Is there any simple way to complete this simple operation, change <code>varchar(50)</code> to <code>varchar(255)</code></p>