June 22, 2009 at 5:02 am
properly exceedingly obvious but is not to me ...
what meta-data can I use to differeniate between a catalogue or a comptibility view ?
to clarify Im not asking what they actually do .. Im asking is there a system table which tells me which camp a particular view belongs to ?
thank you simon
June 22, 2009 at 5:16 am
As far as I know the only way is to read about it in BOL. If it exists just for backward compatibility, BOL will state so.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 22, 2009 at 6:35 am
possibly my fault for not explaining... I know why they exists I want a method of ifentifying all catalogue views and all compatibitly views seperately
thanks simon
June 22, 2009 at 6:56 am
I'm not sure if it is a hard rule, but I would say that all the compatibilty views have a name starting with sys versus the new catalogue views, which are just in the sys schema but don't have a name prefix sys.
[font="Verdana"]Markus Bohse[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply