lundi 17 août 2015

SQLITE pure permanent column alias

I have a problem similar to Alias Column Names at the Database Level [MySQL]

It was in 2013, may be status as changed in 2015 so I am asking again :)

I got a table with auto generated names for columns that can be a bit long and with '.' and '^' chars in there, the number of columns this way can be high.

This is ok, I can always quote this later in queries.

Ex: select 'a.c.d^e.f' from t

Now for popular request, i.e columns used very often, I'd like to be able to setup an alias name, I fear the answer is NO , yet asking :)

Dreaming about creating an aditional column afterward like this

alter table t alias [column] 'a.c.d^e.f' to F

I could then issue: select F from t; Would be short no quote etc...

Thanx in advance Phi

Aucun commentaire:

Enregistrer un commentaire