msdbデータベースのテーブル一覧 - kk_AtakaのScrapbox

msdbデータベースのテーブル一覧

code:sql

use msdb;

select s.name as schema_name, t.name as table_name from sys.schemas s, sys.tables t where s.schema_id = t.schema_id order by table_name asc;

実際に見てみる

table:result

schema_name table_name

dbo autoadmin_managed_databases

dbo autoadmin_master_switch

dbo autoadmin_system_flags

dbo autoadmin_task_agent_metadata

dbo autoadmin_task_agents

dbo backupfilegroup

dbo backupmediafamily

dbo backupmediaset

dbo dm_hadr_automatic_seeding_history

dbo external_libraries_installed

dbo log_shipping_monitor_alert

dbo log_shipping_monitor_error_detail

dbo log_shipping_monitor_history_detail

dbo log_shipping_monitor_primary

dbo log_shipping_monitor_secondary

dbo log_shipping_primaries

dbo log_shipping_primary_databases

dbo log_shipping_primary_secondaries

dbo log_shipping_secondaries

dbo log_shipping_secondary

dbo log_shipping_secondary_databases

dbo logmarkhistory

dbo msdb_version

dbo MSdbms_datatype

dbo MSdbms_datatype_mapping

dbo restorefile

dbo restorefilegroup

dbo restorehistory

dbo smart_backup_files

dbo sqlagent_info

dbo suspect_pages

dbo syscachedcredentials

dbo syscategories

dbo syscollector_blobs_internal

dbo syscollector_collection_items_internal

dbo syscollector_collection_sets_internal

dbo syscollector_collector_types_internal

dbo syscollector_config_store_internal

dbo syscollector_execution_log_internal

dbo syscollector_execution_stats_internal

dbo syscollector_tsql_query_collector

dbo sysdac_history_internal

dbo sysdac_instances_internal

dbo sysdbmaintplan_databases

dbo sysdbmaintplan_history

dbo sysdbmaintplan_jobs

dbo sysdbmaintplans

dbo sysdownloadlist

dbo sysjobactivity

dbo sysjobhistory

dbo sysjobschedules

dbo sysjobservers

dbo sysjobsteps

dbo sysjobstepslogs

dbo sysmail_account

dbo sysmail_attachments

dbo sysmail_attachments_transfer

dbo sysmail_configuration

dbo sysmail_log

dbo sysmail_mailitems

dbo sysmail_principalprofile

dbo sysmail_profile

dbo sysmail_profileaccount

dbo sysmail_query_transfer

dbo sysmail_send_retries

dbo sysmail_server

dbo sysmail_servertype

dbo sysmaintplan_log

dbo sysmaintplan_logdetail

dbo sysmaintplan_subplans

dbo sysmanagement_shared_registered_servers_internal

dbo sysmanagement_shared_server_groups_internal

dbo sysnotifications

dbo sysoperators

dbo sysoriginatingservers

dbo syspolicy_conditions_internal

dbo syspolicy_configuration_internal

dbo syspolicy_execution_internal

dbo syspolicy_facet_events

dbo syspolicy_management_facets

dbo syspolicy_object_sets_internal

dbo syspolicy_policies_internal

dbo syspolicy_policy_categories_internal

dbo syspolicy_policy_category_subscriptions_internal

dbo syspolicy_policy_execution_history_details_internal

dbo syspolicy_policy_execution_history_internal

dbo syspolicy_system_health_state_internal

dbo syspolicy_target_set_levels_internal

dbo syspolicy_target_sets_internal

dbo sysproxylogin

dbo sysproxysubsystem

dbo sysschedules

dbo syssessions

dbo sysssispackagefolders

dbo sysssispackages

dbo syssubsystems

dbo systargetservergroupmembers

dbo systargetservergroups

dbo systargetservers

dbo sysutility_mi_configuration_internal

dbo sysutility_mi_cpu_stage_internal

dbo sysutility_mi_dac_execution_statistics_internal

dbo sysutility_mi_session_statistics_internal

dbo sysutility_mi_smo_objects_to_collect_internal

dbo sysutility_mi_smo_properties_to_collect_internal

dbo sysutility_mi_smo_stage_internal

dbo sysutility_mi_volumes_stage_internal

dbo sysutility_ucp_aggregated_dac_health_internal

dbo sysutility_ucp_aggregated_mi_health_internal

dbo sysutility_ucp_computer_cpu_health_internal

dbo sysutility_ucp_computers_stub

dbo sysutility_ucp_configuration_internal

dbo sysutility_ucp_cpu_utilization_stub

dbo sysutility_ucp_dac_file_space_health_internal

dbo sysutility_ucp_dac_health_internal

dbo sysutility_ucp_dacs_stub

dbo sysutility_ucp_databases_stub

dbo sysutility_ucp_datafiles_stub

dbo sysutility_ucp_filegroups_stub

dbo sysutility_ucp_filegroups_with_policy_violations_internal

dbo sysutility_ucp_health_policies_internal

dbo sysutility_ucp_logfiles_stub

dbo sysutility_ucp_managed_instances_internal

dbo sysutility_ucp_mi_database_health_internal

dbo sysutility_ucp_mi_file_space_health_internal

dbo sysutility_ucp_mi_health_internal

dbo sysutility_ucp_mi_volume_space_health_internal

dbo sysutility_ucp_policy_check_conditions_internal

dbo sysutility_ucp_policy_target_conditions_internal

dbo sysutility_ucp_policy_violations_internal

dbo sysutility_ucp_processing_state_internal

dbo sysutility_ucp_smo_servers_stub

dbo sysutility_ucp_snapshot_partitions_internal

dbo sysutility_ucp_space_utilization_stub

dbo sysutility_ucp_supported_object_types_internal

dbo sysutility_ucp_volumes_stub