Is changing the position of a column possible?

[Shweta]

Hi All,

Just want to know if we can change the sequence of columns appearing in a table.

For example, I had a table with two columns i.e. ProductId and ProductName. I added a column 'ID' later on to this table marked as primary key. But the thing is, it got added at the end. That means 'ID' column is the third column in my table however I wanted it to appear as first column.

Please suggest on it.

Thanks in advance!

Regards,
Shweta Jain

 

[AliGW]

You can select and drag columns in tables to your preferred position by clicking on the column header and dragging.

 

[Shweta]

Okay..thank you

However I have to do it every time I run the select query

Is there a way to make it permanent?

 

[xenou]

Create a new table - fill it with the data from the old one. Then drop the old table and rename the new one. Always be sure to have a backup before operations like this.