Adding a new column between the existing column using T-sql

Posted by Self-innovator under Sql Server category on 12/30/2011 | Points: 40 | Views : 1582

Post Code |

Search Codes |

Code Home

consider the existing table Persons
Columns:Name,Age and City
I want to add new column between Name and Age as Email through t-SQL
select Name,cast(null as varchar(50)) as 'Email',Age,City into tempPersons from Persons
drop table Persons//drop existing table
exec sp_rename 'tempPersons','Persons'//rename the table

Alert Moderator