Search code examples
sqlpowershellsqlcmd

How do I return column headers when there are no rows returned with Invoke-Sqlcmd?

When executing a query using Invoke-Sqlcmd, if no rows are returned, the result is just $null.

I wondering if it's possible to still return the column headers, but with no data. This would make it consistent with a query which did return rows.

Is there an easy way to do this?

Solution

  • If you get a null back try this query:

    select [COLUMN_NAME] from information_schema.columns where TABLE_NAME='TABLENAME'