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
Filed Under [ Practical Answers SQL ]

Comments

No comments posted yet.

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