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
-
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