Link Search Menu Expand Document Documentation Menu

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

Babelfish for PostgreSQL Links