How to exclude a column using SELECT * [except columnA] in Sybase

Question

I want to select all columns but remove some columns in Sybase. What is the solution for this?

I want something like this:

select * 
from table_name 
except [column_names]

There is no function available for Sybase for this use case and the 'exclude' keyword like snowflake does not work here.

Answer 1

The question is basically a duplicate of this one: Exclude a column using SELECT * [except columnA] FROM tableA?

There are possible workarounds that work with standard SQL, like using this temp table approach (if the performance hit is acceptable)

Because Sybase has some "non-standard SQL features", but as you mentioned not the EXCLUDE keyword (or a similar feature) which is a non-standard Snowflake extension.