Skip to main content

Index Reference

Complete Index Listing

TableIndex NameTypeUniqueColumns
SA_SQLServer_AdditionalInformationPK_SA_SQLServer_AdditionalInformationCLUSTEREDYesid
SA_SQLServer_AdditionalInformationUQ_SA_SQLServer_AdditionalInformation_AdditionalInformationNONCLUSTEREDYesmd5_additional_information
SA_SQLServer_AsymmetricKeysUQ_SA_SQLServer_AsymmetricKeys_TypeNONCLUSTEREDYesdatabase_id, name
SA_SQLServer_AuditActionsUQ_SA_SQLServer_AuditActionsNONCLUSTEREDYesaction_id, class_type, parent_class_type
SA_SQLServer_AuditClassTypePK_SA_SQLServer_AuditClassTypeCLUSTEREDYesclass_type
SA_SQLServer_AuditFilesPK_SA_SQLServer_AuditFilesCLUSTEREDYesid
SA_SQLServer_AuditFilesUQ_SA_SQLServer_AuditFiles_Path_Audit_IdNONCLUSTEREDYesaudit_id, md5_audit_file_path
SA_SQLServer_AuditInformationPK_SA_SQLServer_AuditInformationCLUSTEREDYesid
SA_SQLServer_ColumnsUQ_SA_SQLServer_Columns_NameNONCLUSTEREDYesobject_id, column_id, name
SA_SQLServer_DatabasePermissionsPK_SA_SQLServer_DatabasePermissionsCLUSTEREDYesid
SA_SQLServer_DatabasePermissionsSA_SQLServer_DatabasePermissions_Database_Id_Grantee_Principal_IXNONCLUSTEREDNodatabase_id, grantee_principal
SA_SQLServer_DatabasePrincipalsPK_SA_SQLServer_DatabasePrincipalsCLUSTEREDYesid
SA_SQLServer_DatabasePrincipalsUQ_SA_SQLServer_DatabasePrincipals_IdNONCLUSTEREDYesdatabase_id, principal_id
SA_SQLServer_DatabasePrincipalsUQ_SA_SQLServer_DatabasePrincipals_NameIdNONCLUSTEREDYesdatabase_id, principal_id, principal_name
SA_SQLServer_DatabasePrincipalsUQ_SA_SQLServer_DatabasePrincipals_NameSidNONCLUSTEREDYesdatabase_id, principal_sid, principal_name
SA_SQLServer_DatabasePrincipalsIX_SA_SQLServer_Objects_Database_Id_Principal_IdNONCLUSTEREDNodatabase_id, principal_id
SA_SQLServer_DatabasePrincipalTypesPK_SA_SQLServer_DatabasePrincipalTypesCLUSTEREDYestype
SA_SQLServer_DatabasePrincipalTypesUQ_SA_SQLServer_DatabasePrincipalTypes_TypeNONCLUSTEREDYestype
SA_SQLServer_DatabasePrincipalTypesUQ_SA_SQLServer_DatabasePrincipalTypes_TypeDescNONCLUSTEREDYestype_desc
SA_SQLServer_DatabaseRoleMembersPK_SA_SQLServer_DatabaseRolesCLUSTEREDYesid
SA_SQLServer_DatabasesPK_SA_SQLServer_DatabasesCLUSTEREDYesid
SA_SQLServer_DatabasesSA_SQLServer_Databases_name_IDXNONCLUSTEREDNoname
SA_SQLServer_DatabasesUQ_SA_SQLServer_DatabasesNONCLUSTEREDYesinstance_id, database_id, name, create_date, sa_delete_date
SA_SQLServer_EventDatabasePrincipalsPK_SA_SQLServer_EventDatabasePrincipalsCLUSTEREDYesid
SA_SQLServer_EventDatabasePrincipalsUQ_SA_SQLServer_EventDatabasePrincipals_IdNameSidNONCLUSTEREDYesdatabase_id, principal_id, principal_name
SA_SQLServer_EventDatabasesPK_SA_SQLServer_EventDatabasesCLUSTEREDYesid
SA_SQLServer_EventDatabasesSA_SQLServer_EventDatabases_name_IDXNONCLUSTEREDNoname
SA_SQLServer_EventDatabasesUQ_SA_SQLServer_EventDatabasesNONCLUSTEREDYesinstance_id, name
SA_SQLServer_EventsUQ_SA_SQLServer_Events_StaleDataLookupNONCLUSTEREDNofile_id, event_time
SA_SQLServer_EventServerPrincipalsPK_SA_SQLServer_EventServerPrincipalsCLUSTEREDYesid
SA_SQLServer_EventServerPrincipalsUQ_SA_SQLServer_EventServerPrincipals_IdNameSidNONCLUSTEREDYesinstance_id, principal_id, principal_sid, principal_name
SA_SQLServer_ExpressionDependenciesPK (auto)CLUSTEREDYesid
SA_SQLServer_ExpressionDependenciesIDX_SA_SQLServer_ExpressionDependencies_IdsNONCLUSTEREDNoinstance_id, database_id, referencing_id
SA_SQLServer_InstancesPK_SA_SQLServer_InstancesCLUSTEREDYesid
SA_SQLServer_InstancesUQ_SA_SQLServer_Instances_NameNONCLUSTEREDYesname
SA_SQLServer_ObjectsPK_SA_SQLServer_ObjectsCLUSTEREDYesid
SA_SQLServer_ObjectsUQ_SA_SQLServer_Objects_IdNONCLUSTEREDYesinstance_id, database_id, object_id
SA_SQLServer_ObjectsUQ_SA_SQLServer_Objects_NameNONCLUSTEREDYesinstance_id, database_id, name, schema_id
SA_SQLServer_ObjectsIX_SA_SQLServer_Objects_Database_Id_Object_IdNONCLUSTEREDNoname, is_deleted, database_id, object_id
SA_SQLServer_ObjectsSA_SQLServer_Objects_Instance_Id_Object_Id_Is_Deleted_IXNONCLUSTEREDNoid, name, instance_id, object_id, is_deleted
SA_SQLServer_PermissionClassesPK_PermissionClassesCLUSTEREDYesclass
SA_SQLServer_PermissionClassesUQ_SA_SQLServer_PermissionClasses_ClassNONCLUSTEREDYesclass
SA_SQLServer_PermissionClassesUQ_SA_SQLServer_PermissionClasses_ClassDescNONCLUSTEREDYesclass_desc
SA_SQLServer_PermissionNamesPK_SA_SQLServer_PermissionNamesCLUSTEREDYestype
SA_SQLServer_PermissionNamesUQ_SA_SQLServer_PermissionNames_PermissionNameNONCLUSTEREDYespermission_name
SA_SQLServer_PermissionNamesUQ_SA_SQLServer_PermissionNames_TypeNONCLUSTEREDYestype
SA_SQLServer_PermissionStatesPK_SA_SQLServer_PermissionStatesCLUSTEREDYesstate
SA_SQLServer_PermissionStatesUQ_SA_SQLServer_PermissionStates_StateNONCLUSTEREDYesstate
SA_SQLServer_PermissionStatesUQ_SA_SQLServer_PermissionStates_StateDescNONCLUSTEREDYesstate_desc
SA_SQLServer_SchemasPK_SA_SQLServer_SchemasCLUSTEREDYesid
SA_SQLServer_SchemasUQ_SA_SQLServer_Schemas_IDsNONCLUSTEREDYesdatabase_id, schema_id
SA_SQLServer_SDD_CriteriaPK_SA_SQLServer_SDD_CriteriaCLUSTEREDYesid
SA_SQLServer_SDD_CriteriaUQ_SA_SQLServer_SDD_Criteria_patternNONCLUSTEREDYespattern_guid
SA_SQLServer_SDD_DatabaseCriteriaSA_SQLServer_SDD_DatabaseCriteria_database_idNONCLUSTEREDNodatabase_id
SA_SQLServer_SDD_MatchHits_SubjectProfilePK_SA_SQLServer_SDD_MatchHits_SubjectProfileCLUSTEREDYesresource_id, criteria_id, source_id, identity_id, attribute_id, order
SA_SQLServer_SDD_ResourcesPK_SA_SQLServer_SDD_ResourcesCLUSTEREDYesid
SA_SQLServer_SDD_ResourcesSA_SQLServer_SDD_Resources_Database_Id_Object_Id_IXNONCLUSTEREDNodatabase_id, object_id
SA_SQLServer_SDD_ResourcesUQ_SA_SQLServer_SDD_Resources_ResourceNONCLUSTEREDYestype, instance_id, database_id, object_id, column_id
SA_SQLServer_SDD_ResourceTypesPK_SA_SQLServer_ResourceTypesCLUSTEREDYesid
SA_SQLServer_SDD_ResourceTypesUQ_SA_SQLServer_ResourceTypes_TypeDescNONCLUSTEREDYestype_desc
SA_SQLServer_SDD_ScanHistoryPK_SA_SQLServer_SDD_ScanHistoryCLUSTEREDYesid
SA_SQLServer_SDD_SupportedDataTypesPK_SA_SQLServer_SDD_SupportedDataTypesCLUSTEREDYesid
SA_SQLServer_SDD_SupportedDataTypesIX_SA_SQLServer_SDD_SupportedDataTypesNONCLUSTEREDYesdata_type
SA_SQLServer_ServerPermissionsPK_SA_SQLServer_ServerPermissionsCLUSTEREDYesid
SA_SQLServer_ServerPrincipalsPK_SA_SQLServer_ServerPrincipalsCLUSTEREDYesid
SA_SQLServer_ServerPrincipalsUQ_SA_SQLServer_ServerPrincipals_IdNONCLUSTEREDYesinstance_id, principal_id
SA_SQLServer_ServerPrincipalsUQ_SA_SQLServer_ServerPrincipals_NameIdNONCLUSTEREDYesinstance_id, principal_id, principal_name
SA_SQLServer_ServerPrincipalsUQ_SA_SQLServer_ServerPrincipals_NameSidNONCLUSTEREDYesinstance_id, principal_sid, principal_name
SA_SQLServer_ServerPrincipalTypesPK_SA_SQLServer_ServerPrincipalTypesCLUSTEREDYestype
SA_SQLServer_ServerPrincipalTypesUQ_SA_SQLServer_ServerPrincipalTypes_TypeNONCLUSTEREDYestype
SA_SQLServer_ServerPrincipalTypesUQ_SA_SQLServer_ServerPrincipalTypes_TypeDescNONCLUSTEREDYestype_desc
SA_SQLServer_ServerRoleMembersPK_SA_SQLServer_ServerRoleMembersCLUSTEREDYesid
SA_SQLServer_SqlLoginsPK_SA_SQLServer_SqlLoginsCLUSTEREDYesid
SA_SQLServer_StatementsPK_SA_SQLServer_QueriesCLUSTEREDYesid
SA_SQLServer_StatementsUQ_SA_SQLServer_Statements_StatementNONCLUSTEREDYesmd5_statement
SA_SQLServer_UserEventsPK_SA_SQLServer_UserEventsCLUSTEREDYesid
SA_SQLServer_UserEventsSA_SQLServer_UserEvents_user_defined_event_id_IDXNONCLUSTEREDNouser_defined_event_id
SA_SQLServer_UserEventsUQ_SA_SQLServer_UserEvents_UserDefinedInformationNONCLUSTEREDYesmd5_user_defined_information
SA_SQL_InstancesPK_SA_SQL_InstancesCLUSTEREDYesinstance_id
SA_SQL_InstancesUQ_SA_SQL_InstancesNONCLUSTEREDYesinstance_label
SA_SQL_InstancesUQ_SA_SQL_Instances_Host_Name_Service_Name_PortNONCLUSTEREDYeshost_name, service_name, port_number
SA_SQL_PatchesPK_SA_SQL_PatchesCLUSTEREDYesPatch_Source, Patch_Version
SA_SQL_PasswordIssues_LISTSA_SQL_PasswordIssues_LIST_PK_IndexNONCLUSTEREDYesrowGUID
SA_SQL_PasswordIssues_LISTSA_SQL_PasswordIssues_LIST_Host_IndexNONCLUSTEREDNoSA_HOST
SA_SQL_PasswordIssues_LISTSA_SQL_PasswordIssues_LIST_JobRuntimeKey_IndexNONCLUSTEREDNoJobRunTimeKey