sql server 系统视图
select * from sys.all_columns
go
select * from sys.databases
go
select * from sys.indexes
[SYS.]
all_columns
all_objects
all_parameters
all_sql_modules
all_views
allocation_units
assemblies
assembly_files
assembly_modules
assembly_references
assembly_types
asymmetric_keys
backup_devices
certificates
CHECK_CONSTRAINTS
check_constraints
COLUMN_DOMAIN_USAGE
COLUMN_PRIVILEGES
column_type_usages
column_xml_schema_collection_usages
COLUMNS
columns
computed_columns
configurations
CONSTRAINT_COLUMN_USAGE
CONSTRAINT_TABLE_USAGE
conversation_endpoints
conversation_groups
credentials
crypt_properties
data_spaces
database_files
database_mirroring
database_mirroring_endpoints
database_mirroring_witnesses
database_permissions
database_principal_aliases
database_principals
database_recovery_status
database_role_members
databases
default_constraints
destination_data_spaces
dm_broker_activated_tasks
dm_broker_connections
dm_broker_forwarded_messages
dm_broker_queue_monitors
dm_clr_appdomains
dm_clr_loaded_assemblies
dm_clr_properties
dm_clr_tasks
dm_db_file_space_usage
dm_db_index_usage_stats
dm_db_mirroring_connections
dm_db_missing_index_details
dm_db_missing_index_group_stats
dm_db_missing_index_groups
dm_db_partition_stats
dm_db_session_space_usage
dm_db_task_space_usage
dm_exec_background_job_queue
dm_exec_background_job_queue_stats
dm_exec_cached_plans
dm_exec_connections
dm_exec_query_memory_grants
dm_exec_query_optimizer_info
dm_exec_query_resource_semaphores
dm_exec_query_stats
dm_exec_query_transformation_stats
dm_exec_requests
dm_exec_sessions
dm_fts_active_catalogs
dm_fts_index_population
dm_fts_memory_buffers
dm_fts_memory_pools
dm_fts_population_ranges
dm_io_backup_tapes
dm_io_cluster_shared_drives
dm_io_pending_io_requests
dm_os_buffer_descriptors
dm_os_child_instances
dm_os_cluster_nodes
dm_os_hosts
dm_os_latch_stats
dm_os_loaded_modules
dm_os_memory_allocations
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_objects
dm_os_memory_pools
dm_os_performance_counters
dm_os_ring_buffers
dm_os_schedulers
dm_os_stacks
dm_os_sublatches
dm_os_sys_info
dm_os_tasks
dm_os_threads
dm_os_virtual_address_dump
dm_os_wait_stats
dm_os_waiting_tasks
dm_os_worker_local_storage
dm_os_workers
dm_qn_subscriptions
dm_repl_articles
dm_repl_schemas
dm_repl_tranhash
dm_repl_traninfo
dm_tran_active_snapshot_database_transactions
dm_tran_active_transactions
dm_tran_current_snapshot
dm_tran_current_transaction
dm_tran_database_transactions
dm_tran_locks
dm_tran_session_transactions
dm_tran_top_version_generators
dm_tran_transactions_snapshot
dm_tran_version_store
DOMAIN_CONSTRAINTS
DOMAINS
endpoint_webmethods
endpoints
event_notification_event_types
event_notifications
events
extended_procedures
extended_properties
filegroups
foreign_key_columns
foreign_keys
fulltext_catalogs
fulltext_document_types
fulltext_index_catalog_usages
fulltext_index_columns
fulltext_indexes
fulltext_languages
http_endpoints
identity_columns
index_columns
indexes
internal_tables
KEY_COLUMN_USAGE
key_constraints
key_encryptions
linked_logins
login_token
master_files
master_key_passwords
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
parameters
partition_functions
partition_parameters
partition_range_values
partition_schemes
partitions
plan_guides
procedures
REFERENTIAL_CONSTRAINTS
remote_logins
remote_service_bindings
routes
ROUTINE_COLUMNS
ROUTINES
schemas
SCHEMATA
securable_classes
server_assembly_modules
server_event_notifications
server_events
server_permissions
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
sql_dependencies
sql_logins
sql_modules
stats
stats_columns
symmetric_keys
synonyms
sysaltfiles
syscacheobjects
syscharsets
syscolumns
syscomments
sysconfigures
sysconstraints
syscurconfigs
syscursorcolumns
syscursorrefs
syscursors
syscursortables
sysdatabases
sysdepends
sysdevices
sysfilegroups
sysfiles
sysforeignkeys
sysfulltextcatalogs
sysindexes
sysindexkeys
syslanguages
syslockinfo
syslogins
sysmembers
sysmessages
sysobjects
sysoledbusers
sysopentapes
sysperfinfo
syspermissions
sysprocesses
sysprotects
sysreferences
sysremotelogins
syssegments
sysservers
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
systypes
sysusers
TABLE_CONSTRAINTS
TABLE_PRIVILEGES
TABLES
tables
tcp_endpoints
trace_categories
trace_columns
trace_event_bindings
trace_events
trace_subclass_values
traces
transmission_queue
trigger_events
triggers
type_assembly_usages
types
user_token
via_endpoints
VIEW_COLUMN_USAGE
VIEW_TABLE_USAGE
VIEWS
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