So you’ve created a table already and realize you need to change a column to a different name. Easy peasy one liner to do this:
alter table t1 rename column a1 to b1;
Now, column a1 is now b1.
sten's entertainment blog.
sten's entertainment blog.
So you’ve created a table already and realize you need to change a column to a different name. Easy peasy one liner to do this:
alter table t1 rename column a1 to b1;
Now, column a1 is now b1.
Recent Comments