Move a Column
Moves a column in the table to a specified position.
Overview
This procedure can move a column in a table to a new position. This is useful when you want to bring important data to the front, match a preferred column order for readability, or prepare your table for export or integration with other systems. To use this procedure, specify which table you're working with and the new position for the column.
Input Concepts
Concept
Type
Description
Default
Required
table
table
The table containing the column.
No default
Yes
new column number
int
The new position for the column.
No default
Yes
Output Concepts
Concept
Description
table
The table with the column moved.
Examples
1. Move a Column in a Sample Table
create a sample table
move the table's "City" column where
the new column number is 1Name
City
Number
Address
john
San Francisco
+ 1 (415) 691 9426
123 east street
joe
San Jose
+ 1 (415) 691 1234
321 west street
jack
San Francisco
+ 1 (415) 691 4595
213 north street
Last updated
Was this helpful?
