从PowerShell sql查询中获取列的名称

$connectionString = "Data Source=服务器地址;Initial Catalog=数据库名;User ID=用户名;Password=密码"
$connection = New-Object System.Data.SqlClient.SqlConnection($connectionString)
$connection.Open()

$query = "SELECT * FROM 表名"
$command = New-Object System.Data.SqlClient.SqlCommand($query, $connection)
$reader = $command.ExecuteReader()

$schemaTable = $reader.GetSchemaTable()
$columnNames = @()
foreach ($row in $schemaTable.Rows) {
    $columnName = $row["ColumnName"]
    $columnNames += $columnName
}

$connection.Close()