How do I get rid of the dbo extension on the tables in my new SQL db
that I switched from an access DB using the upsizing wizard???
My table look like this:

dbo.table1
dbo.table2
dbo.table3

I want them to look like this:

anew.table1
anew.table2
anew.table3

I can change one table at a time with this SQL statement:

ALTER SCHEMA anew TRANSFER dbo.table1

But there are over 1000 tables, how do I do it in a loop?

Thanks,

Apryl

MS Sql Server LazyDBA home page