Not sure in Navigator but ALTER TABLE can, excerpt from the manual.
ALTER TABLE table-name
COLUMN ADD column-definition BEFORE column-name
I would assume that Navigator could do this also.
Scott
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Cunningham
Sent: Friday, October 03, 2014 12:26 PM
To: Midrange Systems Technical Discussion
Subject: reordering SQL defined table
Is there a way using System i Navigator when defining columns for an SQL table, to reorder the existing columns? Like if the table has 50 columns and you are adding a new column but don't want it on the end, is there a way to add it as the 10th column on the table? In DDS days that was done by moving he lines of DDS source code around and doing a CHGPF
Mike Cunningham
Vice President of Information Technology Services/CIO Pennsylvania College of Technology
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
