Insert new column instead of append

From: GregS (anonymous_at_discussions.microsoft.com)
Date: 09/07/04 

Date: Tue, 7 Sep 2004 12:42:50 -0700

Is anyone aware of Transact-SQL commands/system procedures
that permit a column to be inserted into a table
structure, a la Enterprise Manager, as opposed to simply
appending, as ALTER TABLE does? We're looking to automate
updates over a range of servers/databases, so Enterprise
Manager is out. Alternately, how about a method for
reordering columns? I understand this is a cosmetic
issue, and I don't want to update system tables. Thanks.

Loading