Moving objects from one schema to another

Hi,
In SQL Server 2005 is there an easy way to move tables, SPs, views etc out
of the default dbo schema and into a new schema?
I can't find anything on Google or in BOL about this...
Thanks,
MarkCheck out:
http://msdn2.microsoft.com/en-us/library/ms173423.aspx
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"Mark Rae" <mark@.markNOSPAMrae.com> wrote in message
news:eS8ZS8v5GHA.696@.TK2MSFTNGP06.phx.gbl...
Hi,
In SQL Server 2005 is there an easy way to move tables, SPs, views etc out
of the default dbo schema and into a new schema?
I can't find anything on Google or in BOL about this...
Thanks,
Mark|||Hello Mark,
MR> In SQL Server 2005 is there an easy way to move tables, SPs, views
MR> etc out of the default dbo schema and into a new schema?
MR> I can't find anything on Google or in BOL about this...
Have a look-see at ALTER SCHEMA.
http://msdn2.microsoft.com/en-us/library/ms173423.aspx
Thanks,
Kent Tegels
http://staff.develop.com/ktegels/|||"Kent Tegels" <ktegels@.develop.com> wrote in message
news:b87ad7460258c8b4ee4d678a30@.news.microsoft.com...
> Have a look-see at ALTER SCHEMA.
> http://msdn2.microsoft.com/en-us/library/ms173423.aspx
Excellent! Thanks.|||"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OJWsyEw5GHA.1012@.TK2MSFTNGP05.phx.gbl...
> http://msdn2.microsoft.com/en-us/library/ms173423.aspx
Excellent! Thanks.