THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Administration » Maintenance » schema   (RSS)
  • Using the catalog views : clearing out a "botched" schema

    A user on StackOverflow had populated a custom schema with a bunch of tables, and needed to replace them with a new set of tables due to various changes. But he couldn't just drop them all in any arbitrary order, because there were foreign keys in place. His workaround was to just run a ''drop all tables'' script multiple times until there were no ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on July 7, 2011
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement