I am using the mssql extension which allows me to connect to my database and query it. I would like to use Cursor to create a query based on that metadata, for example: Generate a CREATE VIEW script for every table in schema ‘xyz’. Add a where clause [abc] = 10 if column [abc] exists in the table.
Is this possible? If yes, how?
I could also use a SSDT database project that resides on my local drive if that works better.
Johan