title: How to alter table when full text search is enabled?
body: <p>I have address table in which city field have nvarchar datatype, but I want to change datatype nvarchar to varchar. For that I have write the script </p>
  
  <pre><code>ALTER TABLE Address ALTER COLUMN City varchar(50) null
  </code></pre>
  
  <p>but when I execute this I have got the error message:</p>
  
  <blockquote>
    <p>Msg 7614, Level 16, State 1, Line 1 Cannot alter or drop column 'City'
    because it is enabled for Full-Text Search.</p>
  </blockquote>
  
  <p>So how  can I resolve this error?
  I don't know anything about full text search.</p>