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

Comments (1) | Share

This should work for SQL Server 2005/2008--

ALTER SCHEMA  SchemaNameForTarget TRANSFER SchemaNameOfSource.MyTableName

example:

ALTER SCHEMA RiskEvaluation TRANSFER dbo.ConvertibleDebenture