Any table column should be able to be hidden - by Rob Farley

Status : 

 


33
1
Sign in
to vote
ID 3139953 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 8/26/2017 9:32:18 PM
Access Restriction Public

Description

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 
Sign in to post a comment.
Posted by John Q. Martin on 9/12/2017 at 1:42 AM
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.