有没有办法将MSSQL表列作为参数传递给powershell函数？

# 导入SMO模块
Import-Module "C:\Program Files\Microsoft SQL Server\140\SDK\Assemblies\Microsoft.SqlServer.Smo.dll"

# 连接到MSSQL数据库
$serverName = "localhost"
$databaseName = "YourDatabase"
$connectionString = "Data Source=$serverName;Initial Catalog=$databaseName;Integrated Security=True"
$connection = New-Object Microsoft.SqlServer.Management.Common.ServerConnection
$connection.ConnectionString = $connectionString
$server = New-Object Microsoft.SqlServer.Management.Smo.Server($connection)

# 获取表列信息
$tableName = "YourTable"
$columnName = "YourColumn"
$database = $server.Databases[$databaseName]
$table = $database.Tables[$tableName]
$column = $table.Columns[$columnName]

# 定义PowerShell函数，接收表列作为参数
function Process-Column {
    param(
        [Microsoft.SqlServer.Management.Smo.Column]$column
    )

    # 在这里编写你的逻辑代码，处理表列
    # 你可以使用$column对象的属性和方法来操作表列

    # 示例：打印表列的名称和数据类型
    Write-Host "Column Name: $($column.Name)"
    Write-Host "Data Type: $($column.DataType)"
}

# 调用函数，传递表列作为参数
Process-Column -column $column