---

$tableName = [string]$Item
Write-Host "TableName = [$tableName]"
try {
$cmd = $Connection.CreateCommand()

$cmd.CommandText = "SELECT [Goods supplier number] FROM [$tableName] WHERE 1 = 0"

$cmd.ExecuteReader().Close()

$cmd.Dispose()
} catch {
$cmd = $Connection.CreateCommand()

$cmd.CommandText = "ALTER TABLE [$tableName] ADD [Goods supplier number] TEXT(50)"

Write-Host $cmd.CommandText

$cmd.ExecuteNonQuery() | Out-Null

$cmd.Dispose()
}
try {
$cmd = $Connection.CreateCommand()

$cmd.CommandText = "SELECT [Goods supplier name] FROM [$tableName] WHERE 1 = 0"

$cmd.ExecuteReader().Close()

$cmd.Dispose()
} catch {
$cmd = $Connection.CreateCommand()

$cmd.CommandText = "ALTER TABLE [$tableName] ADD [Goods supplier name] TEXT(255)"

Write-Host $cmd.CommandText

$cmd.ExecuteNonQuery() | Out-Null

$cmd.Dispose()
}
try {
$cmd = $Connection.CreateCommand()

$cmd.CommandText = "SELECT [Complete Name] FROM [$tableName] WHERE 1 = 0"

$cmd.ExecuteReader().Close()

$cmd.Dispose()
} catch {
$cmd = $Connection.CreateCommand()

$cmd.CommandText = "ALTER TABLE [$tableName] ADD [Complete Name] TEXT(255)"

Write-Host $cmd.CommandText

$cmd.ExecuteNonQuery() | Out-Null

$cmd.Dispose()
}