SQL view have three view options
1) with schemabinding
2) with encryption
3) With view_metadata
I have perfectly understood the first and second but I am unable understand with view_metadata what's its purpose when it is used? why it is used?
Although there is am information on this topic at this url (http://technet.microsoft.com/en-us/library/ms187956.aspx) but i am unable to make out what is the situation at which this option has to be used. Can you give examples for that?