Removal of programmable object
I’m evaluating whether SQL Change Automation, is a good fit for our Data Warehouse development cycle.
Looking at the documentation for Programmable Objects, and also testing in Visual Studio – I can’t figure out how to handle the removal of ex. a stored procedure?
Let’s say I have some stored procedure that I want to remove from the database – I therefore delete the programmable object in my SQL Change Automation project.. But this won’t delete the stored procedure in the database, but just the SQL Change Automation project.
Therefore my question is:
How do I delete a programmable object in the SQL Change Automation project, so that it is also reflected in the actual target database?