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,
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/
|||Check 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
|||"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.