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
No comments:
Post a Comment