View

[sonal]

I am creating views. Now the situation is such that i want to alter that view with retrieving the records from the same view but the error comes as:

View or function 'newmspearl.dbo.property' contains a self-reference. Views or functions cannot reference themselves directly or indirectly.

here:
newmspearl is a database name
dbo is a user name
property is a view name

[skhanal]

The error message explains it, you can't create a view on top of the same view.