Gossamer Forum
Home : General : Databases and SQL :

Reorganize the columns in a LinksSQL table

Quote Reply
Reorganize the columns in a LinksSQL table
Hi

I want to reorganize the columns in a Links SQL table.

i.e. Move the column named "Company" from position 20 to position 4 etc

I have MySQLMan and can see where to add a column into a set position but not to move columns.

Any pointers ?

Regards

minesite
Quote Reply
Re: [minesite] Reorganize the columns in a LinksSQL table In reply to
Hi,

GT::SQL doesn't support this directly, so what you need to do is:

1. Move the columns via MySQLMan or SQL:

ALTER TABLE table CHANGE COLUMN col same type info AFTER other_col

2. Then run resync table from the admin to update the .def file.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] Reorganize the columns in a LinksSQL table In reply to
Thanks

Regards

minesite