Manual
Search…
⌃K

Out-DataTable



Out-DataTable

SYNOPSIS

Creates a DataTable for an object

SYNTAX

Out-DataTable [-InputObject] <PSObject[]> [-NonNullable <String[]>] [<CommonParameters>]

DESCRIPTION

Creates a DataTable based on an object's properties.

EXAMPLES

EXAMPLE 1

$dt = Get-psdrive | Out-DataTable
# This example creates a DataTable from the properties of Get-psdrive and assigns output to $dt variable

EXAMPLE 2

Get-Process | Select Name, CPU | Out-DataTable | Invoke-SQLBulkCopy -ServerInstance $SQLInstance -Database $Database -Table $SQLTable -force -verbose
# Get a list of processes and their CPU, create a datatable, bulk import that data

PARAMETERS

InputObject

-InputObject <PSObject[]>
One or more objects to convert into a DataTable
Required? true
Position? 1
Default value
Accept pipeline input? true (ByValue)
Accept wildcard characters? false

NonNullable

-NonNullable <String[]>
A list of columns to set disable AllowDBNull on
Required? false
Position? named
Default value @()
Accept pipeline input? false
Accept wildcard characters? false

CommonParameters

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.