Sql2008 System VIEW Angkor:

TABLE_PRIVILEGES
dm_os_hosts
dm_os_memory_brokers
openkeys
dm_os_memory_allocations
dm_db_mirroring_past_actions
dm_xe_session_object_columns
dm_os_loaded_modules
dm_db_task_space_usage
dm_os_memory_objects
DOMAINS
dm_audit_class_type_map
dm_os_schedulers
dm_os_dispatcher_pools
dm_os_threads
SCHEMATA
ROUTINE_COLUMNS
dm_exec_requests
dm_tran_commit_table
dm_fts_outstanding_batches
dm_repl_tranhash
dm_qn_subscriptions
dm_db_session_space_usage
dm_exec_query_optimizer_info
dm_xe_map_values
dm_tran_top_version_generators
dm_fts_fdhosts
dm_xe_sessions
trigger_event_types
COLUMNS
traces
dm_os_waiting_tasks
dm_exec_background_job_queue
dm_db_missing_index_details
dm_clr_properties
dm_os_sublatches
dm_exec_query_memory_grants
dm_tran_current_snapshot
TABLE_CONSTRAINTS
KEY_COLUMN_USAGE
dm_os_wait_stats
dm_os_memory_node_access_stats
dm_os_spinlock_stats
dm_database_encryption_keys
VIEWS
dm_broker_connections
dm_db_mirroring_auto_page_repair
VIEW_COLUMN_USAGE
dm_os_dispatchers
dm_os_stacks
ROUTINES
dm_xe_session_targets
dm_audit_actions
dm_os_ring_buffers
DOMAIN_CONSTRAINTS
dm_db_missing_index_groups
dm_exec_cached_plans
user_token
dm_exec_sessions
dm_broker_forwarded_messages
dm_resource_governor_resource_pools
dm_os_memory_clerks
dm_repl_articles
dm_xe_session_events
dm_fts_memory_buffers
dm_fts_index_population
CONSTRAINT_COLUMN_USAGE
securable_classes
dm_tran_current_transaction
dm_os_child_instances
dm_exec_connections
system_components_surface_area_configuration
dm_exec_background_job_queue_stats
event_notification_event_types
dm_filestream_file_io_handles
dm_fts_active_catalogs
dm_tran_database_transactions
dm_filestream_file_io_requests
dm_cdc_log_scan_sessions
dm_os_memory_cache_clock_hands
dm_repl_schemas
dm_db_mirroring_connections
dm_db_partition_stats
trace_event_bindings
dm_os_sys_memory
trace_events
dm_io_pending_io_requests
dm_os_nodes
COLUMN_DOMAIN_USAGE
dm_os_memory_cache_entries
dm_os_virtual_address_dump
VIEW_TABLE_USAGE
dm_cryptographic_provider_properties
PARAMETERS
dm_tran_transactions_snapshot
dm_os_memory_cache_hash_tables
dm_cdc_errors
dm_resource_governor_configuration
dm_exec_query_stats
trace_columns
REFERENTIAL_CONSTRAINTS
fulltext_system_stopwords
dm_clr_tasks
dm_os_worker_local_storage
dm_db_persisted_sku_features
dm_db_index_usage_stats
dm_os_buffer_descriptors
dm_tran_active_snapshot_database_transactions
dm_tran_active_transactions
dm_db_file_space_usage
dm_broker_activated_tasks
dm_broker_queue_monitors
dm_os_memory_cache_counters
CHECK_CONSTRAINTS
dm_tran_session_transactions
trace_categories
dm_clr_appdomains
dm_exec_trigger_stats
dm_os_memory_pools
fulltext_languages
dm_os_latch_stats
dm_io_backup_tapes
dm_resource_governor_workload_groups
dm_fts_memory_pools
dm_os_sys_info
dm_tran_locks
dm_exec_procedure_stats
dm_exec_query_transformation_stats
dm_exec_query_resource_semaphores
dm_repl_traninfo
dm_db_missing_index_group_stats
dm_fts_population_ranges
trace_subclass_values
dm_os_performance_counters
TABLES
dm_os_workers
CONSTRAINT_TABLE_USAGE
dm_xe_session_event_actions
COLUMN_PRIVILEGES
dm_db_script_level
dm_server_audit_status
dm_io_cluster_shared_drives
dm_os_tasks
fulltext_document_types
login_token
dm_xe_packages
spatial_reference_systems
dm_os_memory_nodes
dm_tran_version_store
dm_os_cluster_nodes
dm_os_process_memory
dm_xe_objects
dm_xe_object_columns
dm_clr_loaded_assemblies
fulltext_stopwords
fulltext_stoplists
fulltext_index_fragments
database_audit_specification_details
database_audit_specifications
conversation_priorities
change_tracking_tables
spatial_index_tessellations
spatial_indexes
function_order_columns
sql_expression_dependencies
table_types
system_sql_modules
system_internals_allocation_units
system_internals_partition_columns
system_internals_partitions
plan_guides
module_assembly_usages
type_assembly_usages
fulltext_index_catalog_usages
service_queue_usages
parameter_type_usages
column_type_usages
message_type_xml_schema_collection_usages
parameter_xml_schema_collection_usages
column_xml_schema_collection_usages
asymmetric_keys
internal_tables
certificates
crypt_properties
key_encryptions
symmetric_keys
xml_schema_collections
transmission_queue
routes
remote_service_bindings
xml_schema_component_placements
xml_schema_wildcard_namespaces
xml_schema_wildcards
xml_schema_attributes
xml_schema_model_groups
xml_schema_elements
xml_schema_facets
xml_schema_types
xml_schema_components
xml_schema_namespaces
extended_properties
database_files
conversation_endpoints
conversation_groups
service_contract_usages
services
service_contract_message_usages
service_contracts
service_message_types
fulltext_catalogs
destination_data_spaces
partition_schemes
filegroups
data_spaces
partition_range_values
partition_parameters
partition_functions
assembly_references
assembly_files
assemblies
database_permissions
database_role_members
database_principal_aliases
database_principals
schemas
assembly_types
types
sql_dependencies
service_queues
synonyms
numbered_procedure_parameters
numbered_procedures
assembly_modules
sql_modules
trigger_events
events
event_notifications
triggers
procedures
foreign_key_columns
foreign_keys
default_constraints
check_constraints
key_constraints
fulltext_index_columns
fulltext_indexes
stats_columns
stats
index_columns
allocation_units
partitions
xml_indexes
indexes
identity_columns
computed_columns
system_parameters
parameters
system_columns
columns
system_views
system_objects
extended_procedures
views
tables
objects
server_audit_specification_details
server_audit_specifications
server_file_audits
server_audits
change_tracking_databases
server_principal_credentials
cryptographic_providers
resource_governor_resource_pools
resource_governor_workload_groups
resource_governor_configuration
server_event_sessions
server_event_session_targets
server_event_session_fields
server_event_session_events
server_event_session_actions
master_key_passwords
database_recovery_status
database_mirroring
credentials
server_assembly_modules
server_sql_modules
server_trigger_events
server_triggers
database_mirroring_endpoints
server_events
server_event_notifications
endpoint_webmethods
service_broker_endpoints
soap_endpoints
via_endpoints
tcp_endpoints
http_endpoints
endpoints
messages
configurations
sql_logins
linked_logins
remote_logins
servers
server_permissions
server_role_members
server_principals
master_files
backup_devices
database_mirroring_witnesses
databases
sysservers
sysremotelogins
sysprocesses
sysperfinfo
sysopentapes
sysoledbusers
sysmessages
syslogins
syslockinfo
sysdevices
sysdatabases
syscursortables
syscursors
syscursorrefs
syscursorcolumns
syscurconfigs
sysconfigures
syscharsets
syslanguages
syscacheobjects
sysaltfiles
sysfiles
sysfilegroups
sysmembers
sysusers
systypes
sysreferences
sysprotects
syspermissions
sysindexkeys
sysindexes
sysfulltextcatalogs
sysconstraints
sysforeignkeys
sysdepends
syscomments
all_sql_modules
syscolumns
sysobjects
all_parameters
all_columns
all_views
all_objects

原文地址:https://www.cnblogs.com/wujiakun/p/VIEW.html