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

posted @ Monday, November 23, 2009 6:04 AM

Feedback

No comments posted yet.

Title:

Name:

Email: Not Displayed

Website:

Comment:

Enter the code shown above