Options

Can flyway refuse to execute code with missing where clause?

SQL Prompt has the "Show execution warnings: Show warnings for statements with an INNER JOIN" that will warn a user in SSMS if execution may affect an undue number of records due to incorrect JOIN or lack of WHERE clause.  Can Flyway CLI do this too?

Answers

  • Options
    Hello DamianWise 

    Thank you for the question. Presently no flyway doesn't do that.
    From a product standpoint, if we were to do that, it would likely be implemented in Flyway Desktop rather than the CLI as it inhabits more of a review and publish workflow, whereas the cli is principally focused on deployments.
    Kind regards
    Peter Laws | Redgate Software
    Have you visited our Help Center?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file