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