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.

Does this answer your question? [Exclude a column using SELECT \* \[except columnA\] FROM tableA?](https://stackoverflow.com/questions/729197/exclude-a-column-using-select-except-columna-from-tablea) — Sandra Rossi, Aug 04 '23 at 11:47

score 0 · Answer 1 · answered Aug 04 '23 at 11:22

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.

1 Answers1