title: Update ANSI_NULLS option in an existing table
body: <p>In our database there is a table which is created with <code>ANSI_NULLS OFF</code>. Now we have created a view using this table. And we want to add a clustered index for this view.</p>
  
  <p>While creating the clustered index it is showing an error like can't create an index since the ANSI_NULL is off for this particular table.</p>
  
  <p>This table contains a large amount of data. So I want to change this option to ON without losing any data.</p>
  
  <p>Is there any way to alter the table to modify this option . Please give your suggestions.</p>