Forum Discussion
venkata-subramanian
Jun 18, 2026Copper Contributor
Feature Proposal: Ability to Exclude a column/subset of Columns in Select.
Summary I would like to propose a new T-SQL feature that allows developers to select all columns from a table while explicitly excluding a small subset of columns. Currently, when a table contains ...
Jamony
Jul 11, 2026MCT
Hi venkata-subramanian, the use case is understandable, especially for wide tables where only one or two columns need to be excluded. The main risk is that select all except style behavior can make production queries fragile when schemas change, but it can be very useful for ad hoc exploration, views, and generated database queries. I would frame the proposal around developer productivity while also suggesting clear rules for column order, computed columns, and compatibility with views.