Microsoft SQL System View Version Map

See all Groups here of look in the table under here:

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.column_xml_schema_collection_usages	•	•	•	•
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.parameter_xml_schema_collection_usages	•	•	•	•
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	•	•	•	•
sys.xml_indexes	•	•	•	•	More Info
sys.xml_schema_attributes	•	•	•	•
sys.xml_schema_collections	•	•	•	•
sys.xml_schema_component_placements	•	•	•	•
sys.xml_schema_components	•	•	•	•
sys.xml_schema_elements	•	•	•	•
sys.xml_schema_facets	•	•	•	•
sys.xml_schema_model_groups	•	•	•	•
sys.xml_schema_namespaces	•	•	•	•
sys.xml_schema_types	•	•	•	•
sys.xml_schema_wildcard_namespaces	•	•	•	•
sys.xml_schema_wildcards	•	•	•	•
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	•	•	•	•

Following groups has been mapped:

• AlwaysOn Availability Groups Catalog Views
• Change Tracking Catalog Views
• CLR Assembly Catalog Views
• Common Language Runtime Related Dynamic Management Views
• Compatibility Views
• Database Mail Views
• Database Related Dynamic Management Views
• Databases and Files Catalog Views
• Data Collector Views
• Data Spaces
• Endpoints Catalog Views
• Execution Related Dynamic Management Views and Functions
• Extended Events Catalog Views
• Extended Properties Catalog Views
• Full-Text Search and Semantic Search Catalog Views
• Full-Text Search Catalog Views
• I/O Related Dynamic Management Views and Functions
• Linked Servers Catalog Views
• Microsoft SQL System View Version Map
• Object Catalog Views
• Partition Function Catalog Views
• Replication Related Dynamic Management Views
• Scalar Types Catalog Views
• Schemas Catalog Views
• Security Catalog Views
• Semantic Search Catalog Views
• Service Broker Catalog Views
• Spatial Data Catalog Views
• SQL Server Operating System Related Dynamic Management Views
• Transaction Related Dynamic Management Views and Functions
• XML Schemas (XML Type System) Catalog Views