Hi
Given a table "ABC" with columns Col1, Col2 and Col3 it is possible to write the following
SELECT
Col1 AS 'ABC_Col1',
Col2 AS 'ABC_Col2',
Col3 AS 'ABC_Col3'
FROM ABC
This is ok, but i have a table with a not fixed set of columns (users are able to append their own columns) where I still need the column prefix (because it is needed in a JOIN/CTE with other tables that also have a Col1, Col2 etc...)
Therefor I would like to be able to write something like this:
SELECT
T0.* AS 'ABC_T.*',
FROM ABC T0
Which is of cause not valid SQL, but can it be done somehow so the "*" columns all get the same prefix?
/Rasmus