How to Add Columns in betwwen of Existing Columns T-SQL Statements

Posted by Self-Innovator under Sql Server on 2/12/2013 | Points: 10 | Views : 1061 | Status : [Member] | Replies : 1
Dear Users,
How to add a new column between the existing columns using T-SQL Statements in SQL Server 2005.
For Example in my existing table i have the columns Id,Name,Age
I need to insert Password column between Name and Age column using transact SQL statement.

Join Hands Change lives
Thanks & Regards
Straight Edge Society


Posted by: Rakesh Singh on: 2/13/2013 [Member] Starter | Points: 25

First of all
1).create new table with needed column.
2).copy data from old table into new table.
3).delete old table.

Self-Innovator, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response