Documentation

Supported System Catalog Views

Babelfish provides limited support for System Catalog Views:

The following System Catalog Views are supported for versions 2.1.0 and higher:

• sys.syslanguages
• sys.indexes
• sys.all_views
• sys.database_files
• sys.sql_modules
• sys.system_sql_modules
• sys.all_sql_modules
• sys.xml_schema_collections
• sys.dm_hadr_database_replica_states
• sys.data_spaces
• sys.database_mirroring
• sys.database_role_members

The following System Catalog Views are supported for versions 1.2.0 and higher:

• sys.dm_os_host_info
• sys.dm_exec_sessions
• sys.dm_exec_connections
• sys.endpoints
• sys.table_types
• sys.database_principals
• sys.sysprocesses
• sys.sysconfigures - a single, read-only configuration setting is currently provided.
• sys.syscurconfigs - a single, read-only configuration setting is currently provided.
• sys.configurations - a single, read-only configuration setting is currently provided.

The following System Catalog Views are supported for versions 1.1.0 and higher:

• sysindexes
• syscolumns
• system_objects
• identity_columns
• types
• check_constraints
• computed_columns
• default_constraints
• index_columns
• sql_modules

The following System Catalog Views are supported for versions 1.0.0 and higher:

• databases
• sysdatabases
• server_principals
• objects
• sysobjects
• all_objects
• schemas
• tables
• indexes
• views
• all_views
• procedures
• extended_properties
• columns
• all_columns
• syscharsets
• assemblies
• assembly_types
• sysforeignkeys
• foreign_key_columns
• foreign_keys
• key_constraints

Unsupported System Catalogs

The following system catalogs are not supported:

• sysallocunits
• sysaltfiles
• sysasymkeys
• sysaudacts
• sysbinobjs
• sysbinsubobjs
• sysbrickfiles
• syscacheobjects
• syscerts
• syscharsets
• syschildinsts
• sysclones
• sysclsobjs
• syscolpars
• syscolumns
• syscomments
• syscompfragments
• sysconfigures
• sysconstraints
• sysconvgroup
• syscscolsegments
• syscscontainers
• syscsdictionaries
• syscsrowgroups
• syscurconfigs
• syscursorcolumns
• syscursorrefs
• syscursors
• syscursortables
• sysdatabases
• sysdbfiles
• sysdbfrag
• sysdbreg
• sysdepends
• sysdercv
• sysdesend
• sysdevices
• sysendpts
• sysextendedrecoveryforks
• sysextfileformats
• sysextsources
• sysexttables
• sysfgfrag
• sysfilegroups
• sysfiles
• sysfiles1
• sysfoqueues
• sysforeignkeys
• sysfos
• sysftinds
• sysftproperties
• sysftsemanticsdb
• sysftstops
• sysfulltextcatalogs
• sysguidrefs
• sysidxstats
• sysindexes
• sysindexkeys
• sysiscols
• syslanguages
• syslnklgns
• syslockinfo
• syslogins
• syslogshippers
• sysmatrixageforget
• sysmatrixages
• sysmatrixbricks
• sysmatrixconfig
• sysmatrixmanagers
• sysmembers
• sysmessages
• sysmultiobjrefs
• sysmultiobjvalues
• sysnsobjs
• sysobjects
• sysobjkeycrypts
• sysobjvalues
• sysoledbusers
• sysopentapes
• sysowners
• sysperfinfo
• syspermissions
• sysphfg
• syspriorities
• sysprivs
• sysprocesses
• sysprotects
• syspru
• sysprufiles
• sysqnames
• sysreferences
• sysremotelogins
• sysremsvcbinds
• sysrmtlgns
• sysrowsetrefs
• sysrowsets
• sysrscols
• sysrts
• sysscalartypes
• sysschobjs
• sysseobjvalues
• sysservers
• syssingleobjrefs
• syssoftobjrefs
• syssqlguides
• system_columns
• system_components_surface_area_configuration
• system_internals_allocation_units
• system_internals_partition_columns
• system_internals_partitions
• system_objects
• system_parameters
• system_sql_modules
• system_views
• systypedsubobjs
• systypes
• sysusermsgs
• sysusers
• syswebmethods
• sysxlgns
• sysxmitbody
• sysxmitqueue
• sysxmlcomponent
• sysxmlfacet
• sysxmlplacement
• sysxprops
• sysxsrvs
• all_columns
• all_objects
• all_parameters
• all_sql_modules
• all_views
• allocation_units
• assemblies
• assembly_files
• assembly_modules
• assembly_references
• assembly_types
• asymmetric_keys
• availability_databases_cluster
• availability_group_listener_ip_addresses
• availability_group_listeners
• availability_groups
• availability_groups_cluster
• availability_read_only_routing_lists
• availability_replicas
• backup_devices
• certificates
• change_tracking_databases
• change_tracking_tables
• check_constraints
• column_encryption_key_values
• column_encryption_keys
• column_master_keys
• column_store_dictionaries
• column_store_row_groups
• column_store_segments
• column_type_usages
• column_xml_schema_collection_usages
• columns
• computed_columns
• configurations
• conversation_endpoints
• conversation_groups
• conversation_priorities
• credentials
• crypt_properties
• cryptographic_providers
• data_spaces
• database_audit_specification_details
• database_audit_specifications
• database_automatic_tuning_mode
• database_automatic_tuning_options
• database_credentials
• database_files
• database_filestream_options
• database_mirroring
• database_mirroring_endpoints
• database_mirroring_witnesses
• database_permissions
• database_principals
• database_query_store_options
• database_recovery_status
• database_role_members
• database_scoped_configurations
• database_scoped_credentials
• databases
• default_constraints
• destination_data_spaces
• dm_audit_actions
• dm_audit_class_type_map
• dm_broker_activated_tasks
• dm_broker_connections
• dm_broker_forwarded_messages
• dm_broker_queue_monitors
• dm_cache_hit_stats
• dm_cache_size
• dm_cache_stats
• dm_cdc_errors
• dm_cdc_log_scan_sessions
• dm_clr_appdomains
• dm_clr_loaded_assemblies
• dm_clr_properties
• dm_clr_tasks
• dm_cluster_endpoints
• dm_column_encryption_enclave
• dm_column_encryption_enclave_operation_stats
• dm_column_store_object_pool
• dm_cryptographic_provider_properties
• dm_database_encryption_keys
• dm_db_column_store_row_group_operational_stats
• dm_db_column_store_row_group_physical_stats
• dm_db_data_pool_nodes
• dm_db_data_pools
• dm_db_external_language_stats
• dm_db_external_script_execution_stats
• dm_db_file_space_usage
• dm_db_fts_index_physical_stats
• dm_db_index_usage_stats
• dm_db_log_space_usage
• dm_db_mirroring_auto_page_repair
• dm_db_mirroring_connections
• dm_db_mirroring_past_actions
• dm_db_missing_index_details
• dm_db_missing_index_group_stats
• dm_db_missing_index_group_stats_query
• dm_db_missing_index_groups
• dm_db_partition_stats
• dm_db_persisted_sku_features
• dm_db_rda_migration_status
• dm_db_rda_schema_update_status
• dm_db_script_level
• dm_db_session_space_usage
• dm_db_storage_pool_nodes
• dm_db_storage_pools
• dm_db_task_space_usage
• dm_db_tuning_recommendations
• dm_db_uncontained_entities
• dm_db_xtp_checkpoint_files
• dm_db_xtp_checkpoint_internals
• dm_db_xtp_checkpoint_stats
• dm_db_xtp_gc_cycle_stats
• dm_db_xtp_hash_index_stats
• dm_db_xtp_index_stats
• dm_db_xtp_memory_consumers
• dm_db_xtp_nonclustered_index_stats
• dm_db_xtp_object_stats
• dm_db_xtp_table_memory_stats
• dm_db_xtp_transactions
• dm_distributed_exchange_stats
• dm_exec_background_job_queue
• dm_exec_background_job_queue_stats
• dm_exec_cached_plans
• dm_exec_compute_node_errors
• dm_exec_compute_node_status
• dm_exec_compute_nodes
• dm_exec_compute_pools
• dm_exec_connections
• dm_exec_distributed_request_steps
• dm_exec_distributed_requests
• dm_exec_distributed_sql_requests
• dm_exec_dms_services
• dm_exec_dms_workers
• dm_exec_external_operations
• dm_exec_external_work
• dm_exec_function_stats
• dm_exec_procedure_stats
• dm_exec_query_memory_grants
• dm_exec_query_optimizer_info
• dm_exec_query_optimizer_memory_gateways
• dm_exec_query_parallel_workers
• dm_exec_query_profiles
• dm_exec_query_resource_semaphores
• dm_exec_query_stats
• dm_exec_query_transformation_stats
• dm_exec_requests
• dm_exec_session_wait_stats
• dm_exec_sessions
• dm_exec_trigger_stats
• dm_exec_valid_use_hints
• dm_external_authentication
• dm_external_script_execution_stats
• dm_external_script_requests
• dm_external_script_resource_usage_stats
• dm_filestream_file_io_handles
• dm_filestream_file_io_requests
• dm_filestream_non_transacted_handles
• dm_fts_active_catalogs
• dm_fts_fdhosts
• dm_fts_index_population
• dm_fts_memory_buffers
• dm_fts_memory_pools
• dm_fts_outstanding_batches
• dm_fts_population_ranges
• dm_fts_semantic_similarity_population
• dm_hadr_ag_threads
• dm_hadr_auto_page_repair
• dm_hadr_automatic_seeding
• dm_hadr_availability_group_states
• dm_hadr_availability_replica_cluster_nodes
• dm_hadr_availability_replica_cluster_states
• dm_hadr_availability_replica_states
• dm_hadr_cluster
• dm_hadr_cluster_members
• dm_hadr_cluster_networks
• dm_hadr_database_replica_cluster_states
• dm_hadr_database_replica_states
• dm_hadr_db_threads
• dm_hadr_instance_node_map
• dm_hadr_name_id_map
• dm_hadr_physical_seeding_stats
• dm_hpc_device_stats
• dm_hpc_thread_proxy_stats
• dm_io_backup_tapes
• dm_io_cluster_shared_drives
• dm_io_cluster_valid_path_names
• dm_io_pending_io_requests
• dm_logpool_hashentries
• dm_logpool_stats
• dm_os_buffer_descriptors
• dm_os_buffer_pool_extension_configuration
• dm_os_child_instances
• dm_os_cluster_nodes
• dm_os_cluster_properties
• dm_os_dispatcher_pools
• dm_os_dispatchers
• dm_os_enumerate_fixed_drives
• dm_os_host_info
• dm_os_hosts
• dm_os_job_object
• dm_os_latch_stats
• dm_os_loaded_modules
• dm_os_memory_allocations
• dm_os_memory_broker_clerks
• dm_os_memory_brokers
• dm_os_memory_cache_clock_hands
• dm_os_memory_cache_counters
• dm_os_memory_cache_entries
• dm_os_memory_cache_hash_tables
• dm_os_memory_clerks
• dm_os_memory_node_access_stats
• dm_os_memory_nodes
• dm_os_memory_objects
• dm_os_memory_pools
• dm_os_nodes
• dm_os_performance_counters
• dm_os_process_memory
• dm_os_ring_buffers
• dm_os_schedulers
• dm_os_server_diagnostics_log_configurations
• dm_os_spinlock_stats
• dm_os_stacks
• dm_os_sublatches
• dm_os_sys_info
• dm_os_sys_memory
• dm_os_tasks
• dm_os_threads
• dm_os_virtual_address_dump
• dm_os_wait_stats
• dm_os_waiting_tasks
• dm_os_windows_info
• dm_os_worker_local_storage
• dm_os_workers
• dm_pal_cpu_stats
• dm_pal_disk_stats
• dm_pal_net_stats
• dm_pal_processes
• dm_pal_spinlock_stats
• dm_pal_vm_stats
• dm_pal_wait_stats
• dm_qn_subscriptions
• dm_repl_articles
• dm_repl_schemas
• dm_repl_tranhash
• dm_repl_traninfo
• dm_resource_governor_configuration
• dm_resource_governor_external_resource_pool_affinity
• dm_resource_governor_external_resource_pools
• dm_resource_governor_resource_pool_affinity
• dm_resource_governor_resource_pool_volumes
• dm_resource_governor_resource_pools
• dm_resource_governor_workload_groups
• dm_server_audit_status
• dm_server_memory_dumps
• dm_server_registry
• dm_server_services
• dm_tcp_listener_states
• dm_tran_aborted_transactions
• dm_tran_active_snapshot_database_transactions
• dm_tran_active_transactions
• dm_tran_commit_table
• dm_tran_current_snapshot
• dm_tran_current_transaction
• dm_tran_database_transactions
• dm_tran_global_recovery_transactions
• dm_tran_global_transactions
• dm_tran_global_transactions_enlistments
• dm_tran_global_transactions_log
• dm_tran_locks
• dm_tran_persistent_version_store
• dm_tran_persistent_version_store_stats
• dm_tran_session_transactions
• dm_tran_top_version_generators
• dm_tran_transactions_snapshot
• dm_tran_version_store
• dm_tran_version_store_space_usage
• dm_xe_map_values
• dm_xe_object_columns
• dm_xe_objects
• dm_xe_packages
• dm_xe_session_event_actions
• dm_xe_session_events
• dm_xe_session_object_columns
• dm_xe_session_targets
• dm_xe_sessions
• dm_xtp_gc_queue_stats
• dm_xtp_gc_stats
• dm_xtp_system_memory_consumers
• dm_xtp_threads
• dm_xtp_transaction_recent_rows
• dm_xtp_transaction_stats
• edge_constraint_clauses
• edge_constraints
• endpoint_webmethods
• endpoints
• event_notification_event_types
• event_notifications
• events
• extended_procedures
• extended_properties
• external_data_sources
• external_file_formats
• external_language_files
• external_languages
• external_libraries
• external_libraries_installed
• external_library_files
• external_library_setup_errors
• external_table_columns
• external_tables
• filegroups
• filetable_system_defined_objects
• filetables
• foreign_key_columns
• foreign_keys
• fulltext_catalogs
• fulltext_document_types
• fulltext_index_catalog_usages
• fulltext_index_columns
• fulltext_index_fragments
• fulltext_indexes
• fulltext_languages
• fulltext_semantic_language_statistics_database
• fulltext_semantic_languages
• fulltext_stoplists
• fulltext_stopwords
• fulltext_system_stopwords
• function_order_columns
• hash_indexes
• http_endpoints
• identity_columns
• index_columns
• index_resumable_operations
• indexes
• internal_partitions
• internal_tables
• key_constraints
• key_encryptions
• linked_logins
• login_token
• masked_columns
• master_files
• master_key_passwords
• memory_optimized_tables_internal_attributes
• message_type_xml_schema_collection_usages
• messages
• module_assembly_usages
• numbered_procedure_parameters
• numbered_procedures
• objects
• openkeys
• parameter_type_usages
• parameter_xml_schema_collection_usages
• parameters
• partition_functions
• partition_parameters
• partition_range_values
• partition_schemes
• partitions
• periods
• plan_guides
• procedures
• query_context_settings
• query_store_plan
• query_store_query
• query_store_query_text
• query_store_runtime_stats
• query_store_runtime_stats_interval
• query_store_wait_stats
• registered_search_properties
• registered_search_property_lists
• remote_data_archive_databases
• remote_data_archive_tables
• remote_logins
• remote_service_bindings
• resource_governor_configuration
• resource_governor_external_resource_pool_affinity
• resource_governor_external_resource_pools
• resource_governor_resource_pool_affinity
• resource_governor_resource_pools
• resource_governor_workload_groups
• routes
• schemas
• securable_classes
• security_policies
• security_predicates
• selective_xml_index_namespaces
• selective_xml_index_paths
• sensitivity_classifications
• sequences
• server_assembly_modules
• server_audit_specification_details
• server_audit_specifications
• server_audits
• server_event_notifications
• server_event_session_actions
• server_event_session_events
• server_event_session_fields
• server_event_session_targets
• server_event_sessions
• server_events
• server_file_audits
• server_memory_optimized_hybrid_buffer_pool_configuration
• server_permissions
• server_principal_credentials
• server_principals
• server_role_members
• server_sql_modules
• server_trigger_events
• server_triggers
• servers
• service_broker_endpoints
• service_contract_message_usages
• service_contract_usages
• service_contracts
• service_message_types
• service_queue_usages
• service_queues
• services
• soap_endpoints
• spatial_index_tessellations
• spatial_indexes
• spatial_reference_systems
• sql_dependencies
• sql_expression_dependencies
• sql_logins
• sql_modules
• stats
• stats_columns
• symmetric_keys
• synonyms
• table_types
• tables
• tcp_endpoints
• time_zone_info
• trace_categories
• trace_columns
• trace_event_bindings
• trace_events
• trace_subclass_values
• traces
• transmission_queue
• trigger_event_types
• trigger_events
• triggers
• trusted_assemblies
• type_assembly_usages
• types
• user_token
• via_endpoints
• views
• xml_indexes
• xml_schema_attributes
• xml_schema_collections
• xml_schema_component_placements
• xml_schema_components
• xml_schema_elements
• xml_schema_facets
• xml_schema_model_groups
• xml_schema_namespaces
• xml_schema_types
• xml_schema_wildcard_namespaces
• xml_schema_wildcards
• syspolicy_configuration
• syspolicy_system_health_state