• I thought "Select *" was banned from production environments for this (and other) reasons.

    Are we saying it is acceptable for View definitions with the caveat that someone remembers to update the definition after a schema change? Wouldn't a schema-bound view make that update more reliable (preventing the change to schema alerts the DBA that the view exists)

    It's a good question; common enough that many would/will encounter the scenario.

    I am curious how we feel about using "select *" in this way.