Inserting New Column In Specific Place

Hi

In MySQL it's simple to insert new columns in specific locations in a table like this


sql Code:






Original
- sql Code





alter table foo add column bar integer not null default 0 after baz






 ALTER TABLE foo ADD COLUMN bar integer NOT NULL DEFAULT 0 AFTER baz



But attempting to do the same thing in MSSQL fails with a syntax error on the word "after." I can insert columns in MSSQL but only if they are added to the end. I looked at the Microsoft insert documentation here but don't see any way to replicate the above MySQL command.

Is there any way to do this in MSSQL? Or do I have to completely recreate all my tables from scratch?

Thanks for any help