Change Display order of Columns in SQL

Question

When a new column is added to a current table, this appears in the last column. eg: added AGE columns to Students table SELECT * FROM Students; "would show the AGE column right at the end.

Question: is it possible to change the order of these columns when such commands are executed?

Please, read this: [PostgreSQL - Is it possible to alter the column order (position) in a table?](https://tableplus.com/blog/2018/09/postgresql-is-it-possible-to-alter-column-order-position-in-a-table.html) — Maciej Los, Sep 11 '20 at 06:13

Morgosus · Answer 1 · 2020-09-11T06:33:44.603

0

If you have an existing table, you could create a VIEW with the columns reorganized, then of course, you could also type out the columns. You could also create a new table.

edited Sep 11 '20 at 06:33

answered Sep 11 '20 at 06:16

Morgosus

807
5
18

1

for which db it will work. as far as I know it is available only in MySQL not in any other DB – Fahmi Sep 11 '20 at 06:25
1

@Fahmi apologies, didn't notice the tag (was looking at the wrong filter, my mistake, removed that part) – Morgosus Sep 11 '20 at 06:29
1

yes I also knew that you didn't look at the tag, however, you can suggest in your answer to create a new table – Fahmi Sep 11 '20 at 06:31
1

that kinda was already there 'or recreate the table as a whole', but I rephrased it – Morgosus Sep 11 '20 at 06:34
will reorganizing the column name on a table level edit ensure the change would be permanent? – hermes-schema Sep 13 '20 at 05:32
yeah, table columns don't shift randomly – Morgosus Sep 13 '20 at 08:29

Change Display order of Columns in SQL

1 Answers1