SQL_Server2005 Tables Schema Changing

[dohamsg]

Hi, using SQL Server 2005.

I've created my 90 tables ( scripted from ERWIN 7.1 ), in management studio, now I want to put each set of tables in their corresponding schemas ( that I created ).

Right now I found only one solution :

ALTER SCHEMA <schema_name> TRANSFER <table_name>

but this method processes only one table each time.

Is there any solution ( GUI or Script ) to move a set of tables to a specified schema?

Thanks indeed.

[chazzy]

probably not, but it wouldn't be so hard to write a script yourself, would it?