Introduction
This tip will explain how to sort a column inside a table.
In order to move the column, you will have to re-declare it (name and field type) and then specify the right position on the table.
Keep in mind that it is a bad practice to depend on the position columns are in a database.
This tip is here for two reasons:
- To help other users do this if they need it.
- To help me find this information again.
Using the Code
In order to make use of the code, you will have to use the SQL editing / execution environment of your database.
Let's imagine you have a table named "contents
". Let's say that inside that table, you have some columns named "Spanish
",
"English
", "German
", and you would like to get them sorted alphabetically.
From:
CONTENTS |
Spanish (text) |
English (text) |
German (text) |
To:
CONTENTS |
English (text) |
German (text) |
Spanish (text) |
The SQL query you should execute to get the result shown in the previous sample is the following one:
alter table CONTENTS change Spanish Spanish text after German
You can see in the SQL query that what you are really making is altering the table by redefining the "Spanish
" column with the same name (Spanish
), and type (t<code>
ext), placing the new "Spanish
" column just after the "German
" column.
This will make it...
I'm from Catalonia (in Spain) and a specialist in CNC, PLC, robotics and automation in general.
From 1998 I've been developing software applications for the automation market.
I'm using different technologies in each case to get the proper result, fieldbus communications, special electronics, special laser sensors, artificial vision, robot arms, CNC applications, PLC's...
www.robotecnik.com[
^] - robots, CNC and PLC programming