title: ALTER TABLE my_table ADD COLUMN column_name VARCHAR(50) AFTER col_name not supported in SQL Server 2000
body: <p>I tried the following query in SQL Server 2000 so that I could add a new column after mentioned column.</p>
  
  <pre><code>alter table abc ADD dad varchar(50) after parentname
  </code></pre>
  
  <p>But it throws me the following error message</p>
  
  <blockquote>
    <p><em>Msg 170, Level 15, State 1, Line 1<br>
    Line 1: Incorrect syntax near 'after'.</em></p>
  </blockquote>
  
  <p>Is there any way to do this in SQL Server 2000?</p>