Returns indexes using a column with the given name.
Find-DbIndexes.ps1 [-ServerInstance] <String> [-Database] <String> [-ColumnName] <String>
[-ProgressAction <ActionPreference>] [<CommonParameters>]
Find-DbIndexes.ps1 -ConnectionString <String> [-ColumnName] <String> [-ProgressAction <ActionPreference>]
[<CommonParameters>]
Find-DbIndexes.ps1 -SmoDatabase <Database> [-ColumnName] <String> [-ProgressAction <ActionPreference>]
[<CommonParameters>]
Find-DbIndexes.ps1 -ConnectionName <String> [-ColumnName] <String> [-ProgressAction <ActionPreference>]
[<CommonParameters>]
Find-DbIndexes.ps1 -ServerInstance '(localdb)\ProjectsV13' -Database AdventureWorks2014 -ColumnName ErrorLogID
SchemaName : dbo TableName : ErrorLog IndexName : PK_ErrorLog_ErrorLogID IndexOrdinal : 1 IsUnique : 1 IsClustered : 1 IsDisabled : 0 ColumnsInIndex : 1
The name of a server (and optional instance) to connect and use for the query. May be used with optional Database, Credential, and ConnectionProperties parameters.
Type: String
Parameter Sets: ByConnectionParameters
Aliases:
Required: True
Position: 1
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
The the database to connect to on the server.
Type: String
Parameter Sets: ByConnectionParameters
Aliases:
Required: True
Position: 2
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
Specifies a connection string to connect to the server.
Type: String
Parameter Sets: ByConnectionString
Aliases: ConnStr, CS
Required: True
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
Specifies an SMO Database object to query.
Type: Database
Parameter Sets: ByDatabase
Aliases:
Required: True
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
The connection string name from the ConfigurationManager to use.
Type: String
Parameter Sets: ByConnectionName
Aliases:
Required: True
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
The column name to search for.
Type: String
Parameter Sets: (All)
Aliases: ColName
Required: True
Position: 3
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
Type: ActionPreference
Parameter Sets: (All)
Aliases: proga
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.