Renaming of lot of columns
Hi! I have table with ~300 columns like this:
Column1 Column2 Column3 … Column300
I have table with ~300 rows like this:
Old name New name
Column1 NewColumn1
Column2 NewColumn2
Column3 NewColumn3
Column300 NewColumn300
I need to rename all columns of the first table in accordance with the rule specified in the second table.
Sure I can do it manually but it is too long way. In addition, this is not the only table I need to rename. Is there a faster way to do this?
Thank you in advance!