I am using the below T-SQL script to modify a table:
ALTER TABLE [dbo].[TBLUSERS1]
ADD [USERPASSWORDDATE] [smalldatetime] NULL
I would like to add the new column at a specific position in the table. Is there a way to do this? Right now, when I run this script, it tacks the new column on the end of the table. I need the new column at a specific location because some programs in my application need particular fields at certain positions.
Thanks for any help