SQL query change column name

Question

I'm working on some current, and archived SQLite databases.

In current versions, a column is named message, but in the archived versions it's named message_id.

The query I'm running is pretty lengthy/complex, and it's just this one column that's changed. Is there any way I can do some kind of CASE EXISTS style query to do this, or am I just going to have to write a separate query?

Gordon Linoff · Accepted Answer · 2021-03-01 13:39:37Z

1

I would suggest writing a view to access the historical data:

create view v_message_history
    select message as message_id, . . . 
    from message_archive;

Then you can use the view and the two columns have the same name.

You could also use alter table to rename the column in either the history or current table. I am guessing, though, that you don't want to do that because it might break existing code.

answered Mar 1, 2021 at 13:39

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL query change column name

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related