Sql server

System Views
Objects, Types and Indexes
sys.dm_db_missing_index_details index_handle
index_handle index_handle sys.objects.type in (‘TA’, ‘AF’ ‘PC’ ‘FS’ ‘FT’ ) , , , , sys.indexes.type_desc=‘XML’ sys.column.is_identity=1

Trace and Eventing
sys.objects.type=‘P’

sys.identity_columns

object_id

sys.xml_indexes using_xml_index_id index_id
index_id

using_xml_index_id primarysys.indexes.type_desc=‘XML’ AND sys.indexes.secondary_type is NULL

object_id

sys.triggers object_id parent_id

object_id object_id

sys.events object_id

sys.trigger_events object_id

sys.procedures object_id
sys.columns.is_computed=1

sys.foreign_keys key_index_id object_id referenced_object_id

object_id

parent_id

secondary sys.xml_indexes.type_desc=‘XML’ ANDsys.indexes.secondary_type is not NULL

sys.fn_trace_geteventinfo() sys.fn_trace_getfilterinfo() sys.fn_trace_getinfo()

sys.server_event_notifications sys.trace_categories sys.trace_columns sys.trace_event_bindings sys.trace_events sys.trace_subclass_values sys.traces

sys.plan_guides scope_object_id
index_handle scope_object_id

sys.computed_columns

sys.sql_modules object_id execute_as_principal_idobject_id

sys.dm_db_missing_index_group_stats group_handle
group_handle

sys.dm_db_missing_index_groups index_group_handle index_handle
index_group_handle

object_id

referenced_object_id, key_index_id

referenced_object_id

sys.plan_guides.scpe_type=1 and sys.objects.tyupe in (P, RF, V, TR, FN, IF, TF, R)

object_id

sys.fn_trace_gettable()

sys.views

sys.synonymssys.parameters object_id system_type_id user_type_id xml_collection_id
object_id

system_type_id, user_type_id

xml_collection_id

sys.dm_db_missing_index_columns() @handle 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
parent_column_idsys.objects.type=‘D’ column_id column_id @handle

sys.objects.type=‘V’

sys.event_notifications

sys.types sys.all_views
system_type_id

system_type_id, user_type_id default_object_id rule_object_id system_type_id user_type_id sys.objects.type=‘R’

object_id object_id

object_id

object_id object_id object_id object_id

sys.extended_procedures
assembly_id

sys.assembly_typesassembly_id

rule_object_id default_object_id system_type_id user_type_id schema_id
schema_id

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

sys.stats
object_id

object_id

sys.check_constraints parent_column_id
parent_column_id sys.objects.type=‘C’ column_id

object_id stats_id
object_id, stats_id

sys.server_events
object_id

sys.server_triggers

sys.all_objectssys.columns column_id default_object_id object_id object_number rule_object_id system_type_id user_type_id xml_collection_id
column_id, object_id object_id, column_id object_id, column_id object_id, column_id object_id, column_id

column_id object_id object_id sys.objects.type=‘R’ object_id rule_object_id default_object_id sys.objects.type=‘D’ object_id xml_collection_id object_id object_idsys.objects object_id parent_object_id principal_id schema_id
object_id

object_id object_id parent_object_id object_id sys.objects.type in (C, D, F, PK, R, TR, UQ) object_id schema_id object_id object_id object_id
ct je ob

sys.objects.type in (‘U’ ‘V’) AND , sys.triggers.parent_class=1

sys.server_trigger_events

sys.default_constraints parent_column_id

system_type_id

user_type_idobject_id

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.key_constraints unique_index_id
unique_index_id sys.indexes.is_unique=1 index_id index_id, object_id sys.objects.type in (‘UQ’ ‘PK’) AND , sys.key_constraints.parent_object_id...