This should work for SQL Server 2005/2008--
ALTER SCHEMA SchemaNameForTarget TRANSFER SchemaNameOfSource.MyTableName
example:
ALTER SCHEMA RiskEvaluation TRANSFER dbo.ConvertibleDebenture
No comments posted yet.