News

Copyright © 2008-2019 Paula DiTallo

Tag Cloud


<< How do I create an Index that is NOT the primary on my tables? | Home | How do I Fix SQL Server error: Order by items must appear in the select list if Select distinct is specified. >>

How do I move a table from one schema to another in SQL Server?

This should work for SQL Server 2005/2008--

ALTER SCHEMA  SchemaNameForTarget TRANSFER SchemaNameOfSource.MyTableName

example:

ALTER SCHEMA RiskEvaluation TRANSFER dbo.ConvertibleDebenture

Monday, November 23, 2009 6:04 AM

Feedback

No comments posted yet.

Post A Comment
Title:
Name:
Email:
Comment:
Verification: