Replies: 1 comment
-
Hi @buck1112 , there's nothing that changes dinamically the query, but you can build it via a script that combines opportunely Get-DbaDbTable to fetch the list of fields you're interested in and then use that info to craft the query for each table. |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
I am working with a script to export to csv files, and I would like to omit the Identity columns in each of the several hundreds of tables.
Is there a parameter that can omit a column based upon data type (e.g. AutoNumber) or the column's position in the table (1st column, 2nd column, etc)? I have gone to get-help invoke-dbaquery, but have found nothing yet.
Thanks for any input.
Beta Was this translation helpful? Give feedback.
All reactions