Cmdlet

Add-OfficeAccessColumn

Module PSWriteOffice

Inputs

OfficeIMO.Access.AccessTable

Outputs

OfficeIMO.Access.AccessColumn

Source

AddOfficeAccessColumnCommand.cs:18 Edit on GitHub

Adds a typed field before rows are appended.

Syntax

Add-OfficeAccessColumn [-AutoNumberSeed <Int32>] [-MaxLength <Int32>] [-Name] <String> [-PassThru] [-Precision <Int32>] [-Scale <Int32>] -Table <AccessTable> [-Type <AccessDataType>] [<CommonParameters>]

Parameter set: All Parameter Sets

Examples

Authored help example

Adds a typed field before rows are appended.

$table | Add-OfficeAccessColumn -Name DisplayName -Type ShortText -MaxLength 120

Parameters

-AutoNumberSeed Int32 optional: First sequential AutoNumber value.
-MaxLength Int32 optional: Maximum short-text length.
-Name String requiredposition: 0: Field name.
-PassThru SwitchParameter optional: Return the created or changed object.
-Precision Int32 optional: Decimal precision.
-Scale Int32 optional: Decimal scale.
-Table AccessTable requiredpipeline: True (ByValue): Table in a newly created database model.
-Type AccessDataType optional: Native field type.; Possible values: AutoNumber, Int32, ShortText, LongText, Currency, Double, DateTime, Boolean, Guid, Binary, Byte, Int16, Single, Decimal, Int64, Complex, ExtendedDateTime, Unknown

Common Parameters

This command supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable.

For more information, see about_CommonParameters.