...bringing you notes from the field...

Tag Cloud


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


  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati