Mediumly long answer, yes (ish) but it's ugly and you probably wouldn't want to do it. please note: this code creates a physical table. CREATE TABLE MyTest (a int, b int, d int, e int) INSERT INTO MyTest (a,b,d,e) VALUES(1,2,4,5) SELECT * FROM MyT

Add the new column to the existing table.(its added to the end of all columns ) Then create a new table using this table and in the sub query which is used to build the new table, mention the columns in the order that you want them in the new table..

Summary: in this tutorial, you will learn how to use the SQL ADD COLUMN clause of the ALTER TABLE statement to add one or more columns to an existing table. Overview of SQL ADD COLUMN clause. To add a new column to a table, you use the ALTER TABLE ADD COL