Ask Paula!

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

  Home  |   Contact  |   Syndication    |   Login
  121 Posts | 5 Stories | 94 Comments | 0 Trackbacks

News

Copyright © 2008-2015 Paula DiTallo

Tag Cloud


Article Categories

Archives

Post Categories

Image Galleries

.NET Development

Enterprise Integration

Entertainment - Games

Java Development

Mobile/PDA Development

Professional Affiliations

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