Geeks With Blogs

News Copyright © 2008-2013 Paula DiTallo
Ask Paula! ...bringing you notes from the field...

This should work for SQL Server 2005/2008--

ALTER SCHEMA  SchemaNameForTarget TRANSFER SchemaNameOfSource.MyTableName

example:

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: GeeksWithBlogs.net | Join free