Published 16 November 2022
Drops all objects in the configured schemas.
Clean is a great help in development and test. It will effectively give you a fresh start, by wiping your configured schemas completely clean. All objects (tables, views, procedures, ...) will be dropped.
Needless to say: do not use against your production DB!
Cleaning additional objects
For complicated database structures an accurate dependency graph cannot always be constructed, so not every object is cleaned. There are also objects that we do not drop as they aren't always safe to, for example, users in SQL Server. To clean additional objects, you can add an afterClean callback defining drop statements. For example afterClean.sql:
DROP USER test_user
See configuration for clean specific configuration parameters.
Didn't find what you were looking for?
- Visit the Redgate forum
- Contact Support