Adding a column after another column within SQL

Question

How do I add a column after another column within MS SQL by using SQL query   TempTable    ID int     Type nvarchar 20      Active bit  NewTable    ID int     Type nvarchar 20      Description text     Active bit  That is what I want  how do I do that

User · Accepted Answer

Assuming MySQL  EDIT  posted before the SQL variant was supplied    ALTER TABLE myTable ADD myNewColumn VARCHAR 255  AFTER myOtherColumn   The AFTER keyword tells MySQL where to place the new column  You can also use FIRST to flag the new column as the first column in the table

User · Answer

In a Firebird database the AFTER myOtherColumn does not work but you can try re-positioning the column using   ALTER TABLE name ALTER column POSITION new position   I guess it may work in other cases as well

User · Answer

It depends on what database you are using  In MySQL  you would use the  ALTER TABLE  syntax  I don t remember exactly how  but it would go something like this if you wanted to add a column called  newcol  that was a 200 character varchar   ALTER TABLE example ADD newCol VARCHAR 200  AFTER otherCol

[sql] Adding a column after another column within SQL

Examples related to sql