Lowell (10/26/2010)
here's a code example to generate all those commands, which can be examined and run seperately:
Lowell, I'd recommend one change to your code - use the QuoteName() function for the schema/table names. For dynamically generated code like this, better to make it bullet-proof.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes