Change Schema on multiple tables

How do I change schema on multiple tables ?
ALTER SCHEMA .....? For more details please refer to the BOL
"Dammark" <dammark@.gmail.com> wrote in message
news:1140429273.758398.79760@.o13g2000cwo.googlegro ups.com...
> How do I change schema on multiple tables ?
>
|||In order to move an object from one schema to another in the same database
the ALTER SCHEMA command can be used.
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
"Dammark" wrote:

> How do I change schema on multiple tables ?
>