Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Simon_L
Starting Member
32 Posts |
 Posted - 2009-06-25 : 10:04:06
|
| properly exceedingly obvious but is not to me ...what meta-data view/table 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 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-25 : 10:11:37
|
What is a "camp"?Books Online has excellent information about which object belogs to either table or view.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-06-26 : 10:07:52
|
| Compatibility views (I believe) are just the views added to SQL Server so it is backward compatible with SQL 2000. Namely sysobjects, sysindexes, sysfiles, etc.. The Catalog views are either sys.objects, sys.indexes, sys.database_files, and so on, or the views in the INFORMATION_SCHEMA schema (how redundant).Nice use of MacBeth, by the way. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-26 : 11:09:55
|
The information_schema views are ANSI compliant.If you look at Oracle, or MySQL, they also have similar information_schema views.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
Simon_L
Starting Member
32 Posts |
Posted - 2009-07-01 : 04:22:58
|
| Thank you both ... yes I understand their purpose ... it was more I wanted to run a query along the lines of something like this select view_name,view_typefrom sys.view_details where view_type in ('catalogue','compatible')(obviously made up but you get the idea !) |
|
|
|
|
|
|
is this a compatibility view I see before me ?