Thanks Mike! I just tried with sp_refreshview which worked great in this scenario.But as suggested by you, it is good to specify all the columns when defining a view.

Thanks,

Deepthi

I have verified that but with schema binding we need to explicitly mention the column names in Select statement. But here I have select * . And if I mention...

Hi,

This is right. So the question posted should have answer, 1,2,3,4 as we have an explicit new line character(char(13) ) introduced.

If we exclude, char(13) then it results in 1, 3,...