Add column error when using AFTER clause

[cdfly]

Hello,
I need to add a column to an existing table using a script. I get an error when I use the AFTER clause.
Here's the statement:
ALTER TABLE testTable
Add newColumn varchar(200) NULL AFTER someColumnName

We are using SQL Server 2000.
There error I'm getting is:
Incorrect syntax near 'AFTER'

 

[markros]

There is no AFTER clause in the SQL Server for ALTER TABLE command. Where did you find this syntax?

PluralSight Learning Library

 

[cdfly]

Interesting. I found some examples on the web, maybe it was Oracle but the examples were in the SQL Server examples

 

[SQLBill]

That is a MySQL command, not a SQL Server command.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[cdfly]

Thanks for the help