Does "text" column have to be last column in table?

[fr2]

I am modifying a SQL Server table which has a "text" column as the last column .... I amm appending about 7 new columns to the end ....

Do I have to make the "text" last? .. I kind of recall (maybe wrongly) .. when there was "memo" field types it had to be last ....

Or am I just ok to append the 7 new columns to the end of the table without haveing to worry about the "text" column being last?

 

[jmeckley]

this is better suited for forum183.

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[jbenson001]

The order of the columns is not relevant.