Hi everybody,

I have a big table in which I need to add several columns in the middle of the columns list.

These are my new fields I need to insert into the columns list.

[Title] [nvarchar](15) NOT NULL,
	[Occupation] [nvarchar](50) NULL,
	[BusinessName] [nvarchar](75) NULL,
	[BusAdd1] [nvarchar](50) NULL,
	[BusAdd2] [nvarchar](25) NULL,
	[BusCity] [nvarchar](22) NULL,
	[BusState] [char](2) NULL,
	[BusZip] [char](7) NULL,
	[Pager] [char](12) NULL,
	[Fax] [char](12) NULL,
	[BusinessPhone] [char](12) NULL,
	[Anniversary] [datetime] NULL,
	[Affiliation] [nvarchar](70) NULL

I can do it in the Designer one by one, but is it a simple way to change the table using script (preserving the original columns and data)?

I assume that with ALTER TABLE command I would add columns at the bottom of the list.

Tnanks in advance.

UPDATE. Ok, according to this http://www.bobsgear.com/display/ts/Adding+Column+After+Another+Column+-+SQL+Server+2005 and articles referenced there I can discard the idea for now and do it at the bottom.