SQLServer2008系统视图_sql视图怎么打开资源-CSDN文库

5星 · 超过95%的资源需积分: 13 17 浏览量 2012-09-05 16:59:08 上传评论 2 收藏 846KB PDF 举报

资源推荐

资源详情

资源评论

ScopeObject Type Relationship Type

Server scope objects have a shaded

background column list

Dynamic Management View

Dynamic Management Function ()

Catalog View

System Administration

Database scope objects have a white

background column list

Referential Integrity Dependency Inheritance

Base Object Derived Object Function

Function Call

0..many 0..1 1 1..many

All inheritance relationships are 1 to 0..1 cardinality

NOTE: NOT ALL OBJECTS OR POSSIBLE RELATIONSHIPS ARE SHOWN ON THIS POSTER.

Defines a constraint between objects

sys.dm_db_missing_index_group_stats

group_handle

sys.dm_db_missing_index_details

index_handle

sys.dm_db_missing_index_groups

index_group_handle

index_handle

sys.dm_db_missing_index_columns()

@handle

sys.extended_procedures

sys.all_views

sys.all_objects

sys.linked_logins

server_id

sys.servers

server_id

sys.remote_logins

server_id

sys.dm_cir_loaded_assemblies

appdomain_address

assembly_id

sys.dm_cir_appdomains

appdomain_address

sys.assemblies

assembly_id

sys.dm_cir_tasks

appdomain_address

sos_task_address

sys.assembly_references

assembly_id

referenced_assembly_id

sys.assembly_modules

assembly_id

object_id

sys.assembly_les

assembly_id

le_id

sys.soap_endpoints

sys.http_endpoints

sys.tcp_endpoints

sys.via_endpoints

sys.dm_db_mirroring_connection

connection_id

peer_certicate_id

sys.database_mirroring_endpoints

certicate_id

sys.dm_broker_forwarded_messages

conversation_id

sys.transmission_queue

conversation_handle

sys.conversation_endpoints

conversation_id

conversation_handle

conversation_group_id

service_id

service_contract_id

sys.conversation_groups

conversation_group_id

service_id

sys.services

service_queue_id

service_id

sys.service_queues

object_id

sys.service_contracts

service_contract_id

sys.remote_service_bindings

service_contract_id

sys.service_broker_endpoints

certicate_id

sys.service_contract_usages

service_contract_id

service_id

sys.dm_broker_activated_tasks

queue_id

spid

sys.dm_broker_queue_monitors

queue_id

sys.service_message_types

xml_collection_id

message_type_id

sys.certicates

certicate_id

sid

thumbprint

sys.service_queue_usages

service_id

sys.crypt_properties

major_id

thumbprint

sys.openkeys

key_id

sys.symmetric_keys

key_guid

principal_id

symmetric_key_id

sys.key_encryptions

thumbprint

sys.asymmetric_keys

assymetric_key_id

principal_id

sid

thumbprint

sys.master_key_passwords

credential_id

family_guid

sys.credentials

credential_id

sys.database_permissions

grantee_principal_id

grantor_principal_id

sys.database_principals

default_schema_name

principal_id

sid

sys.server_principals

credential_id

principal_id

sid

sys.server_role_members

member_principal_id

role_principal_id

sys.server_permissions

grantee_principal_id

grantor_principal_id

sys.sql_logins

principal_id

sys.endpoint_webmethods

endpoint_id

sys.endpoints

endpoint_id

sys.partition_range_values

function_id

parameter_id

sys.partition_parameters

function_id

parameter_id

system_type_id

sys.partition_functions

function_id

sys.partition_schemes

data_space_id

function_id

sys.tables

lestream_data_space_id

lob_data_space_id

sys.dm_db_index_operational_stats()

index_id

object_id

partition_number

sys.dm_db_index_physical_stats()

index_id

object_id

partition_number

sys.dm_db_partition_stats

index_id

object_id

partition_number

sys.partitions

hobt_id

index_id

object_id

partition_id

partition_number

sys.xml_schema_namespaces

xml_namespace_id

xml_collection_id

sys.key_constraints

unique_index_id

sys.default_constraints

parent_column_id

sys.assembly_types

assembly_id

sys.types

rule_object_id

default_object_id

system_type_id

user_type_id

schema_id

sys.identity_columns

sys.plan_guides

scope_object_id

sys.synonyms

sys.computed_columns

sys.procedures

object_id

sys.sql_modules

object_id

execute_as_principal_id

sys.foreign_keys

key_index_id

object_id

referenced_object_id

sys.xml_indexes

using_xml_index_id

index_id

sys.views

sys.objects

object_id

parent_object_id

principal_id

schema_id

sys.check_constraints

parent_column_id

sys.columns

column_id

default_object_id

object_id

object_number

rule_object_id

system_type_id

user_type_id

xml_collection_id

sys.indexes

data_space_id

index_id

object_id

sys.sql_dependencies

referenced_minor_id

referenced_major_id

object_id

column_id

sys.dm_db_index_usage_stats

object_id

database_id

index_id

sys.foreign_key_columns

constraint_column_id

constraint_object_id

parent_column_id

parent_object_id

referenced_column_id

referenced_object_id

sys.destination_data_spaces

data_space_id

partition_scheme_id

sys.legroups

data_space_id

sys.dm_db_session_space_usage

session_id

sys.data_spaces

data_space_id

sys.master_les

le_id

database_id

data_space_id

sys.dm_db_le_space_usage

le_id

database_id

sys.allocation_units

allocation_unit_id

container_id

data_space_id

sys.database_les

data_space_id

le_id

sys.database_recovery_status

database_id

family_guid

sys.dm_db_task_space_usage

request_id

session_id

sys.dm_io_virtual_le_stats()

le_id

database_id

sys.dm_io_cluster_shared_drives

sys.dm_io_pending_io_requests

sys.databases

database_id

owner_sid

source_database_id

sys.dm_tran_locks

lock_owner_address

resource_associated_entity_id

request_owner_id

request_owner_guid

request_session_id

sys.dm_tran_active_transactions

transaction_id

transaction_uow

sys.dm_tran_session_transactions

session_id

transaction_id

sys.dm_tran_database_transactions

transaction_id

sys.dm_tran_transactions_snapshot

transaction_sequence_num

sys.dm_tran_active_snapshot_database_transactions

transaction_id

transaction_sequence_num

sys.dm_tran_current_transaction

transaction_sequence_num

sys.dm_os_memory_cache_hash_tables

cache_address

sys.dm_os_memory_cache_counters

cache_address

sys.dm_os_memory_cache_clock_hands

cache_address

sys.dm_os_memory_cache_entries

cache_address

memory_object_address

pool_id

sys.dm_os_memory_clerks

memory_clerk_address

page_allocator_address

sys.dm_os_memory_pools

memory_pool_address

sys.dm_os_memory_objects

memory_object_address

page_allocator_address

sys.dm_os_schedulers

scheduler_id

sys.dm_os_tasks

host_address

request_id

scheduler_id

session_id

task_address

worker_address

sys.dm_os_waiting_tasks

blocking_task_address

resource_address

waiting_task_address

sys.dm_exec_connections

connection_id

endpoint_id

most_recent_sql_handle

parent_connection_id

session_id

sys.dm_exec_sessions

endpoint_id

group_id

session_id

sys.dm_exec_cursors()

session_id

sql_handle

sys.dm_exec_sql_text()

@handle

objectid

sys.dm_exec_query_plan()

object_id

@handle

sys.dm_exec_query_stats

sql_handle

plan_handle

sys.dm_exec_requests

connection_id

group_id

plan_handle

request_id

session_id

sql_handle

sys.dm_exec_plan_attributes()

@handle

sys.dm_exec_cached_plans

plan_handle

pool_id

sys.schemas

schema_id

principal_id

sys.xml_schema_collections

xml_collection_id

schema_id

sys.index_columns

object_id

column_id

index_id

sys.stats_columns

stats_id

object_id

column_id

sys.server_trigger_events

sys.server_events sys.server_triggers

sys.stats

object_id

stats_id

sys.parameters

object_id

system_type_id

user_type_id

xml_collection_id

sys.triggers

object_id

parent_id

sys.events

object_id

sys.trigger_events

object_id

Objects, Types and Indexes Trace and Eventing

Linked Servers

Database Mirroring

Endpoints

Service Broker

Security

Resource Governor

Transaction Information

Server-Wide

Information

Execution

Environment

Databases

and Storage

Partitioning

Common

Language

Runtime

sys.dm_resource_governor_workload_groups

group_id

sys.dm_resource_governor_resource_pools

group_id

pool_id

sys.database_role_members

member_ principal_id

role_principal_id

sys.service_contract_message_usages

message_type_id

service_contract_id

sys.column_type_usages

sys.column_xml_schema_collection_usages

sys.extended_properties

sys.internal_tables

sys.parameter_type_usages

sys.parameter_xml_schema_collection_usages

sys.type_assembly_usages

sys.all_columns

sys.all_parameters

sys.all_sql_modules

sys.server_assembly_modules

sys.server_sql_modules

sys.system_columns

sys.system_objects

sys.system_parameters

sys.system_sql_modules

sys.system_views

sys.fn_trace_geteventinfo()

sys.fn_trace_getlterinfo()

sys.fn_trace_getinfo()

sys.fn_trace_gettable()

sys.server_event_notications

sys.trace_categories

sys.trace_columns

sys.trace_event_bindings

sys.trace_events

sys.trace_subclass_values

sys.traces

sys.event_notications

sys.dm_clr_properties

sys.module_assembly_usages

sys.database_mirroring

sys.database_mirroring_witnesses

sys.login_token

sys.user_token

sys.securable_classes

sys.server_audits

sys.server_audit_specications

sys.server_audit_specication_details

sys.server_le_audits

sys.system_components_surface_area_conguration

sys.dm_exec_background_job_queue

sys.dm_exec_background_job_queue_stats

sys.dm_exec_cached_plan_dependent_objects()

sys.dm_exec_query_optimizer_info

sys.dm_exec_text_query_plan()

sys.dm_exec_xml_handles()

sys.congurations

sys.messages

sys.syslanguages

sys.dm_os_buffer_descriptors

sys.dm_os_child_instances

sys.dm_os_cluster_nodes

sys.dm_os_hosts

sys.dm_os_latch_stats

sys.dm_os_loaded_modules

sys.dm_os_performance_counters

sys.dm_os_ring_buffers

sys.dm_os_stacks

sys.dm_os_sys_info

sys.dm_os_threads

sys.dm_os_virtual_address_dump

sys.dm_os_wait_stats

sys.dm_os_worker_local_storage

sys.dm_os_workers

sys.message_type_xml_schema_collection_usages

sys.routes

sys.dm_broker_connections

peer_certicate_id

connection_id

sys.dm_tran_current_snapshot

sys.dm_tran_top_version_generators

sys.dm_tran_version_store

sys.dm_os_memory_brokers

pool_id

index_handle

index_group_handle

group_handle

scope_object_id

system_type_id

object_id

sys.plan_guides.scpe_type=1 and

sys.objects.tyupe in (P, RF, V, TR, FN, IF, TF, R)

sys.columns.is_computed=1

sys.objects.type=‘R’

system_type_id, user_type_id

default_object_id

rule_object_id

system_type_id

user_type_id

schema_id

sys.indexes.type_desc=‘XML’

sys.column.is_identity=1

sys.objects.type=‘P’

object_id

referenced_object_id

referenced_object_id, key_index_id

using_xml_index_id

primary

sys.indexes.type_desc=‘XML’ AND

sys.indexes.secondary_type is NULL

secondary

sys.xml_indexes.type_desc=‘XML’ AND

sys.indexes.secondary_type is not NULL

index_id

object_id

parent_id

object_id

xml_collection_id

system_type_id, user_type_id

object_id

sys.objects.type=‘V’

sys.objects.type=‘D’

sys.objects.type in (‘U’, ‘V’)

object_id

object_id, stats_id

sys.objects.type in (‘U’, ‘V’) AND

sys.triggers.parent_class=1

object_id

schema_id

object_id

parent_object_id

sys.objects.type in (C, D, F, PK, R, TR, UQ)

object_id

sys.objects.type=‘R’

sys.objects.type=‘D’

column_id

object_id

rule_object_id

default_object_id

xml_collection_id

parent_column_id

column_id

system_type_id

user_type_id

sys.objects.type=‘C’

sys.objects.type=‘D’

parent_column_id

assembly_id

server_id server_id server_id server_id

appdomain_address appdomain_address

assembly_id

assembly_id assembly_id

appdomain_address

xml_collection_id

lob_data_space_id

object_id, index_id, partition_number

sys.crypt_properties.class=1

sys.objects.type in (‘UQ’, ‘PK’) AND

sys.key_constraints.parent_object_id is not null

sys.indexes.is_unique=1

unique_index_id

index_id

index_id, object_id

object_id, index_id

object_id, index_id, partition_number

sys.objects.type in (‘U’) AND

sys.indexes.type_desc <> ‘XML’

sys.objects.type in (‘U’, ‘V’)

column_id, object_id

object_id, column_id

column_id, object_id

referenced_minor_id,

referenced_major_id

object_idobject_id

data_space_id

object_id, index_id

sys.objects.type in (‘U’, ‘V’, ‘TF’)

object_id

column_id

object_id, index_id

column_id

object_id, stats_id

xml_collection_id

schema_id

principal_id

constraint_object_id, constraint_column_id

referenced_object_id, referenced_column_id

parent_object_id, parent_column_id

sys.objects.type=‘U’

sys.dm_tran_locks.request_type=‘OBJECT’ and

sys.dm_tran_locks.database_id=db_id()

session_id

session_id, request_id

sql_handle

session_id

plan_handle

@handle

plan_handle

connection_id

session_id, request_id

data_space_id

sys.allocation_unit.type in (1, 3)

sys.allocation_unit.type=2

object_id, index_id

partition_number

object_id, index_id

partition_scheme_id

partition_id

hobt_id

object_id, index_id

partition_number

object_id, index_id

partition_number

object_id, index_id

partition_number

referenced assembly

assembly_id

referenced_assembly_id,

assembly_id

object_id

sos_task_address

system_type_id

function_id

function_id, parameter_id

function_id

data_space_id

database_id

data_space_id

database_id, le_id

container_id

data_space_id

le_id

session_id, request_id

le_id

data_space_id

object_id

@handle

sql_handle

object_id

plan_handle

sql_handle

session_id

endpoint_id

le_id

session_id

database_id, le_id

database_id

family_guid

allocation_unit_id

endpoint_id

sys.endpoints.type=1

master.sys.certicates only

le_id

assembly_id

certicate_id

peer_certicate_id

sys.dm_tran_locks.request_type in

(‘HOBT’, ‘Page”, ‘RID’, ‘Key’) and

sys.dm_tran_locks.database_id=db_id()

sys.dm_tran_locks.request_type=‘ALLOCATION UNIT’

and sys.dm_tran_locks.database_id=db_id()

database_id

owner_sid

source_database_id

request_session_id

resource_associated_entity_id

connection_id

endpoint_id

connection_id

session_id

most_recent_sql_handle

connection_id

parent_connection_id

page_allocator_address

memory_object_

address

memory_pool_address

memory_clerk_address

page_allocator_address

memory_object_

address

memory_clerk_address

cache_address

scheduler_id

session_id, request_id

task_address

waiting_task_address

blocking_task_address

resource_address

session_id

transaction_id

transaction_id,

transaction_uow

request_owner_id

request_owner_guid

lock_owner_address

sys.dm_tran_locks.request_owner_type=‘TRANSACTION’

resource_associated_entity_id

transaction_sequence_num

principal_id

sid

grantee_principal_id

credential_id

credential_idcredential_id

sys.server_principals.type=‘R’

principal_id

member_principal_id

role_principal_id

family_guid

grantee_principal_id,

grantor_principal_id

connection_id

peer_certicate_id

conversation_id

conversation_handle

conversation_group_id

service_id

service_id service_id

service_id

service_contract_id

object_id

service_contract_id

certicate_id

message_type_id

queue_id

spid

service_contract_id

service_id

sys.crypt_properties.class=5

service_queue_id

sys.crypt_properties.crypt_type=SPVA

major_id

thumbprint

certicate_id

xml_collection_id

message_type_id

thumbprint

sys.crypt_properties.crypt_type=CPVO

member_principal_id

role_principal_id

key_id

symmetric_key_id

thumbprint

key_guid

principal_id

certicate_id

sys.database_role_members=‘R’

transaction_id

cache_address

Full Text Search

object_id

table_id

unique_index_id data_space_id

sys.fulltext_indexes

data_space_id

object_id

unique_index_id

sys.fulltext_index_fragments

table_id

index_id

data_space_id

object_id

System Views

object_id

Extended Events

sys.dm_xe_session_targets

event_session_address

target_name

target_package_guid

sys.dm_xe_packages

guid

sys.dm_xe_session_events

event_session_address

event_name

event_package_guid

sys.dm_xe_objects

name

package_guid

sys.dm_xe_object_columns

column_id

object_name

object_package_guid

type_name

type_package_guid

sys.dm_xe_map_values

name

object_package_guid

sys.dm_xe_session_object_columns

event_session_address

column_id

object_name

object_package_guid

sys.dm_xe_session_event_actions

action_name

action_package_guid

event_name

event_package_guid

sys.dm_xe_sessions

address

guid

package_guid

name,

package_guid

target_name,

target_package_guid

name, package_guid

event_session_address

address

event_session_address

addressaddress

event_session_address

type_name, type_package_guid

column_id, object_name,

object_package_guid

name, object_package_guid

column_id, object_name, object_package_guid

event_name,

event_package_guid

event_name, event_package_guid

magazine

sys.objects.type in (‘TA’, ‘AF’, ‘PC’, ‘FS’, ‘FT’,)

@handle

service_id

sys.change_tracking_tables

object_id

sys.dm_lestream_le_io_handles

handle_id

lestream_transaction_id

group_id

pool_id

group_id

sys.dm_exec_query_memory_grants

group_id

pool_id

sys.dm_exec_query_resource_semaphores

pool_id

group_id

pool_id

sys.change_tracking_databases

database_id

object_id

sys.dm_lestream_le_io_requests

handle_id

lestream_transaction_id

transaction_id

sys.dm_audit_actions

sys.dm_audit_class_type_map

sys.dm_server_audit_status

handle_id

connection_id

object_name, object_package_guid

sys.database_audit_specications

sys.database_audit_specications_details

object_id

action_name,

action_package_guid

name, package_guid

The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

本内容试读结束，登录后可阅读更多

下载后可阅读完整内容，剩余0页未读，立即下载

评论收藏

内容反馈

zhfyfd_1

2014-02-19

弄清SQL SERVER中的系统视图，对学习T-SQL有很大的帮助。pdf中包含了各个视图中的关联关系，感谢分享！
fanchao19860916

2014-05-13

还不错的图，可以顺着图区研究

奋斗的小壁虎

粉丝: 241
资源: 54

SQLServer2008系统视图

SQL Server 2008 系统视图预览版

SQL server 2008 索引与视图

sqlserver 2008 索引与视图 详解

数据库ER图

SQL Server数据库的E-R图

sqlserver系统视图与存储过程应用说明

SQL Server 2008完全学习手册视频教程.zip

SQL Server索引视图及性能提高简介

SQL Server数据库实验指导书 实验教程 数据库实验05 视图的创建与使用.pdf

利用SQLServer系统表或视图猜解字段

SQL Server 2008管理员必备指南(超高清PDF)Part1

SQL Server 2008宝典.(电子工业.刘智勇.刘径周).part2

SQLSERVER2008存储结构一_系统视图.doc

SQL Server 2008管理员必备指南(超高清PDF)Part2

SqlServer2008查询性能优化扫描版.part1

SQL Server 2008宝典.(电子工业.刘智勇.刘径周).part4

SQL-Server2008实验报告

SQL Server 2008宝典.(电子工业.刘智勇.刘径周).part1

SQL Server 2008管理员必备指南(超高清PDF)Part3

网上银行系统 java sql server 编程

SQL Server 2008中文版关系数据库基础与实践教程.zip

利用SQL Server 2005索引视图提高数据库系统性能.pdf

从Sqlserver移植到DM参考手册[csdn]

数据库课程设计：高校教务管理系统（Java代码、SQL代码、报告）

sqlserver离线安装包

药品说明书数据库，共计11万+条药品说明书，目前再SQL2008R2数据库验证成功

sqljdbc.zip

2019年最新5级全国行政区划数据库（包括乡镇村）

sql server2019离线安装包

最新资源

sqlserver 2008 索引与视图详解

SQL Server数据库实验指导书实验教程数据库实验05 视图的创建与使用.pdf