---

$Schema = $Connection.GetSchema( "Columns", @($null, $null, $Item, $null) )
$ExistingColumns = @( $Schema | ForEach-Object { $_.COLUMN_NAME } )
if ($ExistingColumns -notcontains "Goods supplier number") {
$cmd = $Connection.CreateCommand()

$cmd.CommandText = @"
ALTER TABLE [$Item] ADD COLUMN [Goods supplier number] TEXT(50) "@
$cmd.ExecuteNonQuery() | Out-Null
$cmd.Dispose()
}
if ($ExistingColumns -notcontains "Goods supplier name") {
$cmd = $Connection.CreateCommand()

$cmd.CommandText = @"
ALTER TABLE [$Item] ADD COLUMN [Goods supplier name] TEXT(255) "@
$cmd.ExecuteNonQuery() | Out-Null
$cmd.Dispose()
}
if ($ExistingColumns -notcontains "Complete Name") {
$cmd = $Connection.CreateCommand()

$cmd.CommandText = @"
ALTER TABLE [$Item] ADD COLUMN [Complete Name] TEXT(255) "@
$cmd.ExecuteNonQuery() | Out-Null
$cmd.Dispose()
}