Adding a column after another column within SQL

How do I add a column after another column within MS SQL by using SQL query?

TempTable ID int, Введите nvarchar (20), Активный бит

NewTable ID int, Введите nvarchar (20), Текст описания, Active bit

That is what I want, how do I do that