The view is a virtual table, Computed_column for view is always false.
is_computed property on view is not correct
Modestas Dromantas
21
Reputation points
A computed column on a table, which is used in view select list, sys.column is not giving correct is_computed property value even after sp_refreshView.
CREATE VIEW dbo.some_view
AS
SEELCT [Computed_column]
FROM dbo.some_table
In sys.columns Computed_column for view will be false, but for table it is true.
Is there any way to work around this? Are there any reasons why a computed property is not reflected, metadata as is_nullable works fine.