Change column names monthly

[Guest_imported]

Hi<br>I need to know if there is a way to change the column names in a table monthly? <br>EG <br>C1, C2, C3, C4<br>C2, C3, C4 will be monthly changing as 20001, 20002, 20003<br>and then<br>20002, 20003, 20004....every month. Please help...Thank you.

 

[listener22]

If you're going to be rebuilding the table each month anyway,
you could have a year column and a month column,
or a year_month column, and then change the values
as you need to each month, rather than change the
column names themselves.