I have a DB with thousands of tables.

I want to copy all tables with name like 'TableType1%' to a new DB.

I can easily get a list of the tables:

> 
> select \* from sys.tables t where schema\_name(t.schema\_id) = 'S1' AND
>  [name] LIKE 'TableType1%'
> 
> 
> 

But how do I copy them to a new DB?

I CANNOT do this manually, as there are too many tables.

I would like to use 

> 
> INSERT INTO
> 
> 
> 

type statement, but don't know how to put it into select statement above.

Something like:

```
select * from sys.tables t 
insert int [NewDB].[S1].[ t.name ] <<< What should go here?
where schema_name(t.schema_id) = 'S1' AND [name] LIKE 'TableType1%'

```