Moving tables to new schema

I am using sql05 and need to move some tables/data/keys to a new
schema (same database).
Any easy way to do that?
thanks, ChuckYou can use ALTER SCHEMA to move an object from one schema to another.
For example to move the HumanResources.Department table to the Sales schema
you can use the following command:
USE AdventureWorks
GO
ALTER SCHEMA Sales TRANSFER HumanResources.Department
HTH
- Peter Ward
WARDY IT Solutions
"Chuck P" wrote:

> I am using sql05 and need to move some tables/data/keys to a new
> schema (same database).
> Any easy way to do that?
> thanks, Chuck
>|||Thanks, you saved me a lot of work, I was getting ready to do it the
old fashion way.
Great command too, my thanks to MS for that one.