Hide a column from all queries unless specifically in select list RRS feed

  • Question

  • We have a legacy database and in some cases I would like to add a new column to a table but am not allowed because it may break old applications that do "SELECT *" from the table. 

    I would love it if I could add the new column as "Hidden" and it would not show in SELECT unless specifically in the select list. 

    These columns would have to be calculated or default and could then be filled by trigger or calculation.

    Thursday, October 8, 2015 3:02 PM