Options

drop table and its dependent objects

neilxneilx Posts: 14
edited May 19, 2008 1:35PM in SQL Refactor Previous Versions
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)?
· Share on Twitter

Comments

  • Options
    Eddie DEddie D Posts: 1,780 Rose Gold 5
    Thank you for your post into the forum.

    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
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
    · Share on Twitter
Sign In or Register to comment.