How do I arrange the column i create to be in a certain order
at the moment I have query to add a column but the column im adding , i want to put before a certain column, example below'
ALTER TABLE Table1 ADD col D Text
example:
col A, col B , col C, col D
I want to put col D before col B
Output Below:
col A, col D, col B , col C