Any table column should be able to be hidden
HIDDEN as a column property is currently only allowed on the system-generated columns in Temporal tables. I think any column should be hidable, so that columns can be added with improved backward compatibility. It would also allow expressions to be added as computed columns and then indexed without changing the results of SELECT *, as in https://connect.microsoft.com/SQLServer/feedback/details/566418/indexes-on-expressions
Upvotes: 33<=-=Sep 12 2017 1:42AM=-=>
From an ISV perspective, adding this capability would add value to the development process for newer versions where feature flags are in use in the application layer controlling access to new experimental features.
Mauro Sturaro commented
We have an application that allows people to customize the attributes of the entities. This is done by adding columns.
Our code would be much simpler and more maintainable if we could mark as HIDDEN all our system columns (Id, CreatedBy, CreatedDateTime, ModifiedBy, ...) and write SELECT Id, * FROM ... instead of generate query at runtime.