drop table and its dependent objects
neilx
Posts: 14
I want to drop some unused tables and the view, stored procedures and functions that reference them - around 120 objects altogether. What is the best way to do this using Red-Gate tools (or not)?
Comments
Unfortunately SQL Refactor will not help in this scenario.
As you are looking to drop unused tables, please take a look at SQL Dependency Tracker or / and SQL Doc. You will then be able to identify the dependent database objects on the tables you wish to drop.
Many Thanks
Eddie
Eddie Davis
Product Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com