Hello there,
i have an interface which allows user to update column & data.
how can i rename a column with sql?
if i'm not mistaken, ALTER TABLE table_name RENAME COLUMN old_col_name to new_col_name is not being supported.
is there a COPY statement? if so, how can i go about using it to rename a column name.
i am also trying on INSERT INTO in conjunction with a SELECT statement but unsuccessful so far.
Any ideas?
Thank You
Astro
