Ask Paula!

...bringing you notes from the field...
posts - 117 , comments - 87 , trackbacks - 0

My Links

News

Copyright © 2008-2014 Paula DiTallo

Tag Cloud

Article Categories

Archives

Post Categories

Image Galleries

.NET Development

Enterprise Integration

Entertainment - Games

Java Development

Mobile/PDA Development

Professional Affiliations

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

Print | posted on Monday, November 23, 2009 6:04 AM | Filed Under [ Practical Answers SQL ]

Feedback

No comments posted yet.
Post A Comment
Title:
Name:
Email:
Comment:
Verification:
 

Powered by: