Geeks With Blogs

News Copyright © 2008-2016 Paula DiTallo

Ask Paula! ...bringing you notes from the field...

This should work for SQL Server 2005/2008--

ALTER SCHEMA  SchemaNameForTarget TRANSFER SchemaNameOfSource.MyTableName


ALTER SCHEMA RiskEvaluation TRANSFER dbo.ConvertibleDebenture

Posted on Monday, November 23, 2009 6:04 AM Practical Answers , SQL | Back to top

Comments on this post: How do I move a table from one schema to another in SQL Server?

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © Paula DiTallo | Powered by: | Join free