Easily done. Easy to drop and recreate, but what if you've populated it?
Here's how to transfer a table to a different schema.
ALTER SCHEMA TargetSchema TRANSFER dbo.myTableCovered this back in 2007 too - Solace : Moving Tables Between Schemas
and 2009 - Solace : Changing Table Schema
No comments:
Post a Comment