Is it possible to have a Select all query except a couple of specific fields?
My use case is to return all fields from MyTable except two specific fields. The table can have some new fields added to it and my goal is to not hard code the select statement when the table layout changes.
SELECT * FROM INFORMATION_SCHEMA.COLUMNSWHERE TABLE_NAME = 'MyTable'
I know my options could include pushing out to a temp table and removing those two fields from the temp table for viewing, or saving the data to an array and pop the two elements. My question is if there is a way to do this as an SQL statement and perhaps 2019 has something obscure?
Open in new window