commands

^

Select-DbaObject

Availability Windows, Linux, macOS

 

Synopsis

Select-DbaObject [-Property <DbaSelectParameter[]>] [-Alias <SelectAliasParameter[]>] [-ScriptProperty <SelectScriptPropertyParameter[]>] [-ScriptMethod <SelectScriptMethodParameter[]>] [-InputObject ] [-ExcludeProperty <string[]>] [-ExpandProperty ] -Unique [-Last ] [-First ] [-Skip ] -Wait [-ShowProperty <string[]>] [-ShowExcludeProperty <string[]>] [-TypeName ] -KeepInputObject []

Select-DbaObject [-Property <DbaSelectParameter[]>] [-Alias <SelectAliasParameter[]>] [-ScriptProperty <SelectScriptPropertyParameter[]>] [-ScriptMethod <SelectScriptMethodParameter[]>] [-InputObject ] [-ExcludeProperty <string[]>] [-ExpandProperty ] -Unique [-SkipLast ] [-ShowProperty <string[]>] [-ShowExcludeProperty <string[]>] [-TypeName ] -KeepInputObject []

Select-DbaObject [-InputObject ] -Unique -Wait [-Index <int[]>] [-ShowProperty <string[]>] [-ShowExcludeProperty <string[]>] [-TypeName ] -KeepInputObject []

Description

Syntax

Select-DbaObjectsyntaxItem                                                                                                                                                                                                                                                                                                                          ----------                                                                                                                                                                                                                                                                                                                          {@{name=

Select-DbaObject; CommonParameters=True; WorkflowCommonParameters=False; parameter=System.Object[]}, @{name=

Select-DbaObject; CommonParameters=True; WorkflowCommonParameters=False; parameter=System.Object[]}, @{name=

Select-DbaObject; CommonParameters=True; WorkflowCommonParameters=False; parameter=System.Object[]}}

 

Examples

 

Optional Parameters

-Alias

Alias
Required False
Pipeline false
Default Value
-ExcludeProperty

Alias
Required False
Pipeline false
Default Value
-ExpandProperty

Alias
Required False
Pipeline false
Default Value
-First

Alias
Required False
Pipeline false
Default Value
-Index

Alias
Required False
Pipeline false
Default Value
-InputObject

Alias
Required False
Pipeline true (ByValue)
Default Value
-KeepInputObject

Alias
Required False
Pipeline false
Default Value
-Last

Alias
Required False
Pipeline false
Default Value
-Property

Alias
Required False
Pipeline false
Default Value
-ScriptMethod

Alias
Required False
Pipeline false
Default Value
-ScriptProperty

Alias
Required False
Pipeline false
Default Value
-ShowExcludeProperty

Alias
Required False
Pipeline false
Default Value
-ShowProperty

Alias
Required False
Pipeline false
Default Value
-Skip

Alias
Required False
Pipeline false
Default Value
-SkipLast

Alias
Required False
Pipeline false
Default Value
-TypeName

Alias
Required False
Pipeline false
Default Value
-Unique

Alias
Required False
Pipeline false
Default Value
-Wait

Alias
Required False
Pipeline false
Default Value

 

Want to see the source code for this command? Check out Select-DbaObject on GitHub.
Want to see the Bill Of Health for this command? Check out Select-DbaObject.