Validate Scheme - similar to VS for DB Pro "Build" e.g. dropping column on table will signal error
Validate Scheme - similar to VS for DB Pro "Build" e.g. dropping column on table will signal error / warning on a view that uses that column.
![](https://secure.gravatar.com/avatar/d1759dbb2460d60bc6cd7d0d16d7cc0f?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
SQL Prompt 5 (expected in Dec 2010 or Jan 2011) will have a feature to find invalid objects. You can get information about current early access releases at http://www.red-gate.com/messageboard/viewforum.php?f=127.
-
Interestingly, this is a feature that is making it into the upcoming SQL Prompt 5 (you can sign up to the early access program to try it out), but it seems like a good idea to have something similar as a pre-commit check in SQL Source Control.