Microsoft SQL System View Version Map

Introduction

Im expanding my SQL Meta Data Framework, and need it to be more version independent.
So i had to look at all the system views in the SQL server and find the differences between versions.

I have postet them on my blog here:

System View Groups that has been mapped:

Transaction Related Dynamic Management Views and Functions

SQL Server Operating System Related Dynamic Management Views

Spatial Data Catalog Views

Service Broker Catalog Views

Semantic Search Catalog Views

Security Catalog Views

Schemas Catalog Views

Scalar Types Catalog Views

Replication Related Dynamic Management Views

Partition Function Catalog Views

Object Catalog Views

Linked Servers Catalog Views

I/O Related Dynamic Management Views and Functions

Full-Text Search Catalog Views

Full-Text Search and Semantic Search Catalog Views

Extended Properties Catalog Views

Extended Events Catalog Views

Execution Related Dynamic Management Views and Functions

Endpoints Catalog Views

Databases and Files Catalog Views

Database Related Dynamic Management Views

Database Mail Views

Data Spaces

Data Collector Views

Compatibility Views

Common Language Runtime Related Dynamic Management Views

CLR Assembly Catalog Views

Change Tracking Catalog Views

AlwaysOn Availability Groups Catalog Views

Microsoft SQL System View Version Map

XML Schemas (XML Type System) Catalog Views

Heres a table view of the systemsviews.

Color definition
	System views are the same in all versions
	System views are partial the same in all versions
	System view does not exists in this version

Click on the bull inside of each version to navigate direct to the MSDN page that contains the information.
Or Click on the More Info in the last column, to see the difference between the versions of the system view.

SystemView	Sql 2005	Sql 2008	Sql 2008 R2	Sql 2012	Difference Info
sys.all_columns	•	•	•	•	More Info
sys.all_objects	•	•	•	•
sys.all_parameters	•	•	•	•
sys.all_sql_modules	•	•	•	•	More Info
sys.all_views	•	•	•	•
sys.allocation_units	•	•	•	•
sys.assemblies	•	•	•	•	More Info
sys.assembly_files	•	•	•	•
sys.assembly_modules	•	•	•	•
sys.assembly_references	•	•	•	•
sys.assembly_types	•	•	•	•	More Info
sys.asymmetric_keys	•	•	•	•	More Info
sys.availability_databases_cluster				•	More Info
sys.availability_group_listener_ip_addresses				•	More Info
sys.availability_group_listeners				•	More Info
sys.availability_groups				•	More Info
sys.availability_groups_cluster				•	More Info
sys.availability_read_only_routing_lists				•	More Info
sys.availability_replicas				•	More Info
sys.backup_devices	•	•	•	•
sys.certificates	•	•	•	•	More Info
sys.change_tracking_databases		•	•	•	More Info
sys.change_tracking_tables		•	•	•	More Info
sys.check_constraints	•	•	•	•
sys.columns	•	•	•	•	More Info
sys.computed_columns	•	•	•	•	More Info
sys.conversation_endpoints	•	•	•	•	More Info
sys.conversation_groups	•	•	•	•
sys.conversation_priorities		•	•	•	More Info
sys.credentials	•	•	•	•	More Info
sys.crypt_properties	•	•	•	•
sys.cryptographic_providers		•	•	•	More Info
sys.data_spaces	•	•	•	•	More Info
sys.database_audit_specification_details		•	•	•	More Info
sys.database_audit_specifications		•	•	•	More Info
sys.database_files	•	•	•	•
sys.database_mirroring	•	•	•	•	More Info
sys.database_mirroring_endpoints	•	•	•	•
sys.database_permissions	•	•	•	•
sys.database_principals	•	•	•	•
sys.database_recovery_status	•	•	•	•
sys.database_role_members	•	•	•	•
sys.databases	•	•	•	•	More Info
sys.default_constraints	•	•	•	•
sys.destination_data_spaces	•	•	•	•
sys.dm_clr_appdomains	•	•	•	•	More Info
sys.dm_clr_loaded_assemblies	•	•	•	•
sys.dm_clr_properties	•	•	•	•
sys.dm_clr_tasks	•	•	•	•
sys.dm_db_file_space_usage	•	•	•	•	More Info
sys.dm_db_partition_stats	•	•	•	•
sys.dm_db_session_space_usage	•	•	•	•
sys.dm_db_task_space_usage	•	•	•	•
sys.dm_exec_background_job_queue	•	•	•	•
sys.dm_exec_background_job_queue_stats	•	•	•	•
sys.dm_exec_cached_plan_dependent_objects	•	•	•	•
sys.dm_exec_cached_plans	•	•	•	•	More Info
sys.dm_exec_connections	•	•	•	•
sys.dm_exec_cursors	•	•	•	•
sys.dm_exec_plan_attributes	•	•	•	•	More Info
sys.dm_exec_query_memory_grants	•	•	•	•	More Info
sys.dm_exec_query_optimizer_info	•	•	•	•
sys.dm_exec_query_plan	•	•	•	•
sys.dm_exec_query_resource_semaphores	•	•	•	•	More Info
sys.dm_exec_query_stats	•	•	•	•	More Info
sys.dm_exec_requests	•	•	•	•	More Info
sys.dm_exec_sessions	•	•	•	•	More Info
sys.dm_exec_sql_text	•	•	•	•
sys.dm_exec_text_query_plan	•	•	•	•
sys.dm_exec_xml_handles	•	•	•	•
sys.dm_io_backup_tapes	•	•	•	•
sys.dm_io_cluster_shared_drives	•	•	•	•
sys.dm_io_pending_io_requests	•	•	•	•
sys.dm_io_virtual_file_stats	•	•	•	•
sys.dm_os_buffer_descriptors	•	•	•	•	More Info
sys.dm_os_child_instances	•	•	•	•
sys.dm_os_cluster_nodes	•	•	•	•	More Info
sys.dm_os_hosts	•	•	•	•
sys.dm_os_latch_stats	•	•	•	•
sys.dm_os_loaded_modules	•	•	•	•
sys.dm_os_memory_cache_clock_hands	•	•	•	•
sys.dm_os_memory_cache_counters	•	•	•	•	More Info
sys.dm_os_memory_cache_entries	•	•	•	•	More Info
sys.dm_os_memory_cache_hash_tables	•	•	•	•
sys.dm_os_memory_clerks	•	•	•	•	More Info
sys.dm_os_memory_objects	•	•	•	•
sys.dm_os_memory_pools	•	•	•	•
sys.dm_os_performance_counters	•	•	•	•
sys.dm_os_schedulers	•	•	•	•	More Info
sys.dm_os_stacks	•	•	•	•
sys.dm_os_sys_info	•	•	•	•	More Info
sys.dm_os_tasks	•	•	•	•	More Info
sys.dm_os_threads	•	•	•	•	More Info
sys.dm_os_virtual_address_dump	•	•	•	•
sys.dm_os_wait_stats	•	•	•	•
sys.dm_os_waiting_tasks	•	•	•	•
sys.dm_os_workers	•	•	•	•	More Info
sys.dm_repl_articles	•	•	•	•
sys.dm_repl_schemas	•	•	•	•
sys.dm_repl_tranhash	•	•	•	•
sys.dm_repl_traninfo	•	•	•	•	More Info
sys.dm_tran_active_snapshot_database_transactions	•	•	•	•
sys.dm_tran_active_transactions	•	•	•	•	More Info
sys.dm_tran_current_snapshot	•	•	•	•
sys.dm_tran_current_transaction	•	•	•	•
sys.dm_tran_database_transactions	•	•	•	•
sys.dm_tran_locks	•	•	•	•
sys.dm_tran_session_transactions	•	•	•	•
sys.dm_tran_top_version_generators	•	•	•	•
sys.dm_tran_transactions_snapshot	•	•	•	•
sys.dm_tran_version_store	•	•	•	•
sys.endpoint_webmethods	•	•	•	•
sys.endpoints	•	•	•	•
sys.event_notifications	•	•	•	•
sys.events	•	•	•	•	More Info
sys.extended_procedures	•	•	•	•
sys.extended_properties	•	•	•	•
sys.filegroups	•	•	•	•	More Info
sys.foreign_key_columns	•	•	•	•
sys.foreign_keys	•	•	•	•
sys.fulltext_catalogs	•	•	•	•	More Info
sys.fulltext_document_types	•	•	•	•
sys.fulltext_index_catalog_usages	•	•	•	•
sys.fulltext_index_columns	•	•	•	•	More Info
sys.fulltext_index_fragments		•	•	•	More Info
sys.fulltext_indexes	•	•	•	•	More Info
sys.fulltext_languages	•	•	•	•
sys.fulltext_semantic_language_statistics_database				•	More Info
sys.fulltext_semantic_languages				•	More Info
sys.fulltext_stoplists		•	•	•	More Info
sys.fulltext_stopwords		•	•	•	More Info
sys.fulltext_system_stopwords		•	•	•	More Info
sys.function_order_columns		•	•	•	More Info
sys.functions	•	•	•	•
sys.http_endpoints	•	•	•	•
sys.identity_columns	•	•	•	•	More Info
sys.index_columns	•	•	•	•	More Info
sys.indexes	•	•	•	•	More Info
sys.internal_tables	•	•	•	•
sys.key_constraints	•	•	•	•
sys.key_encryptions	•	•	•	•
sys.linked_logins	•	•	•	•
sys.master_files	•	•	•	•
sys.master_key_passwords	•	•	•	•
sys.message_type_xml_schema_collection_usages	•	•	•	•
sys.numbered_procedure_parameters	•	•	•	•
sys.numbered_procedures	•	•	•	•
sys.objects	•	•	•	•
sys.parameters	•	•	•	•	More Info
sys.partition_parameters	•	•	•	•	More Info
sys.partition_range_values	•	•	•	•
sys.partition_schemes	•	•	•	•	More Info
sys.partitions	•	•	•	•	More Info
sys.procedures	•	•	•	•
sys.registered_search_properties				•	More Info
sys.registered_search_property_lists				•	More Info
sys.remote_logins	•	•	•	•
sys.remote_service_bindings	•	•	•	•
sys.routes	•	•	•	•
sys.rules	•	•	•	•
sys.schemas	•	•	•	•
sys.server_audit_specification_details		•	•	•	More Info
sys.server_audit_specifications		•	•	•	More Info
sys.server_audits		•	•	•	More Info
sys.server_event_session_actions		•	•	•	More Info
sys.server_event_session_events		•	•	•	More Info
sys.server_event_session_fields		•	•	•	More Info
sys.server_event_session_targets		•	•	•	More Info
sys.server_event_sessions		•	•	•	More Info
sys.server_file_audits		•	•	•	More Info
sys.server_permissions	•	•	•	•
sys.server_principals	•	•	•	•	More Info
sys.server_role_members	•	•	•	•
sys.servers	•	•	•	•	More Info
sys.service_contract_message_usages	•	•	•	•
sys.service_contract_usages	•	•	•	•
sys.service_contracts	•	•	•	•
sys.service_message_types	•	•	•	•
sys.service_queue_usages	•	•	•	•
sys.service_queues	•	•	•	•	More Info
sys.services	•	•	•	•
sys.soap_endpoints	•	•	•	•
sys.spatial_index_tessellations		•	•	•	More Info
sys.spatial_indexes		•	•	•	More Info
sys.sql_dependencies	•	•	•	•
sys.sql_expression_dependencies		•	•	•	More Info
sys.sql_logins	•	•	•	•	More Info
sys.sql_modules	•	•	•	•	More Info
sys.stats	•	•	•	•	More Info
sys.stats_columns	•	•	•	•
sys.symmetric_keys	•	•	•	•	More Info
sys.synonyms	•	•	•	•
sys.sysalt_files	•	•	•	•
sys.syscache_objects	•	•	•	•
sys.syscharsets	•	•	•	•
sys.syscolumns	•	•	•	•
sys.syscomments	•	•	•	•
sys.sysconfigures	•	•	•	•
sys.sysconstraints	•	•	•	•
sys.syscur_configs	•	•	•	•
sys.sysdatabases	•	•	•	•
sys.sysdepends	•	•	•	•	More Info
sys.sysdevices	•	•	•	•
sys.sysfile_groups	•	•	•	•
sys.sysfiles	•	•	•	•
sys.sysforeign_keys	•	•	•	•
sys.sysfulltext_catalogs	•	•	•	•
sys.sysindexes	•	•	•	•	More Info
sys.sysindexkeys	•	•	•	•
sys.syslanguages	•	•	•	•
sys.syslock_info	•	•	•	•
sys.syslogins	•	•	•	•
sys.sysmembers	•	•	•	•
sys.sysmessages	•	•	•	•
sys.sysobjects	•	•	•	•
sys.sysoledbusers	•	•	•	•
sys.sysperf_info	•	•	•	•
sys.syspermissions	•	•	•	•
sys.sysprocesses	•	•	•	•
sys.sysprotects	•	•	•	•
sys.sysreferences	•	•	•	•
sys.sysremote_logins	•	•	•	•
sys.sysservers	•	•	•	•	More Info
sys.system_columns	•	•	•	•	More Info
sys.system_components_surface_area_configuration	•	•	•	•
sys.system_functions	•	•	•	•
sys.system_objects	•	•	•	•
sys.system_parameters	•	•	•	•
sys.system_stored_procedures	•	•	•	•
sys.system_views	•	•	•	•
sys.systypes	•	•	•	•	More Info
sys.sysusers	•	•	•	•
sys.table_types		•	•	•	More Info
sys.tables	•	•	•	•	More Info
sys.tcp_endpoints	•	•	•	•
sys.transmission_queue	•	•	•	•	More Info
sys.trigger_event_types		•	•	•	More Info
sys.trigger_events	•	•	•	•	More Info
sys.triggers	•	•	•	•
sys.types	•	•	•	•	More Info
sys.via_endpoints	•	•	•	•
sys.views	•	•	•	•
syscollector_collection_items		•	•	•	More Info
syscollector_collection_sets		•	•	•	More Info
syscollector_collector_types		•	•	•	More Info
syscollector_config_store		•	•	•	More Info
syscollector_execution_log		•	•	•	More Info
syscollector_execution_log_full		•	•	•	More Info
syscollector_execution_stats		•	•	•	More Info
sysmail_allitems	•	•	•	•
sysmail_event_log	•	•	•	•
sysmail_faileditems	•	•	•	•
sysmail_mailattachments	•	•	•	•
sysmail_sentitems	•	•	•	•
sysmail_unsentitems	•	•	•	•

Hope it helps you as much as it has me... ;)

History

13-12-2012: Added link to the XML Schemas (XML Type System) Catalog Views