Click here to Skip to main content
13,349,997 members (46,861 online)
Click here to Skip to main content
Add your own
alternative version


3 bookmarked
Posted 19 Mar 2012

Sort a Column Inside an Already Created Table

, 7 Sep 2012
Rate this:
Please Sign up or sign in to vote.
This tip will explain how to sort a column inside a table.


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:

  1. To help other users do this if they need it.
  2. 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.


Spanish (text)
English (text)
German (text)


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...


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Joan M
Chief Technology Officer robotecnik
Spain Spain
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...[^] - robots, CNC and PLC programming

You may also be interested in...


Comments and Discussions

GeneralUnclear Pin
PIEBALDconsult7-Sep-12 5:32
memberPIEBALDconsult7-Sep-12 5:32 
QuestionRe: Unclear Pin
Joan Murt7-Sep-12 7:47
memberJoan Murt7-Sep-12 7:47 
AnswerRe: Unclear Pin
John Brett9-Sep-12 22:02
memberJohn Brett9-Sep-12 22:02 
GeneralRe: Unclear Pin
Joan Murt9-Sep-12 22:16
memberJoan Murt9-Sep-12 22:16 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.180111.1 | Last Updated 7 Sep 2012
Article Copyright 2012 by Joan M
Everything else Copyright © CodeProject, 1999-2018
Layout: fixed | fluid