Change schema name on Tables and Stored procedures in SQL Server 2005

Invalid object name ‘umbracoUser’ » Prolific Notion

Invalid object name ‘umbracoUser’ » Prolific Notion — Mon, 16 Feb 2009 21:29:40 GMT

Pingback from Invalid object name ‘umbracoUser’ » Prolific Notion

re: Change schema name on Tables and Stored procedures in SQL Server 2005

Michael Khalsa — Wed, 31 Oct 2007 23:53:16 GMT

Super, Great, saved lots of time changing owner for table and sprocs.

For those who do not quite understand (be sure to change sys.Procedures p

to sys.Tables p) to get your list of table change statements ready to copy from results pane to a new query window, then execute the whole list at once.

re: Change schema name on Tables and Stored procedures in SQL Server 2005

Henrik — Fri, 26 Oct 2007 15:08:26 GMT

yeah verry cool. That helps me to save a lot of time.

Thanks Daniel !!

re: Change schema name on Tables and Stored procedures in SQL Server 2005

Daniel T — Wed, 10 Oct 2007 16:43:47 GMT

For tables and views you can use

SELECT 'ALTER SCHEMA NewSchema TRANSFER ' + TABLE_SCHEMA + '.' + TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'OldSchema'

re: Change schema name on Tables and Stored procedures in SQL Server 2005

BAT — Tue, 09 Oct 2007 09:32:39 GMT

Thanks a lot

U have given a great solution

re: Change schema name on Tables and Stored procedures in SQL Server 2005

jn — Mon, 01 Oct 2007 22:57:13 GMT

You can use "ALTER SCHEMA schema_name TRANSFER securable_name"

re: Change schema name on Tables and Stored procedures in SQL Server 2005

Raul — Fri, 14 Sep 2007 07:33:35 GMT

It works perfectly,

Thanks a ton, but how can we change de function's schema?

re: Change schema name on Tables and Stored procedures in SQL Server 2005

nez — Mon, 03 Sep 2007 07:57:40 GMT

BEAUTIFUL!, thank you very much, save alot time updating a web database.

CHEERS!

re: Change schema name on Tables and Stored procedures in SQL Server 2005

nix — Mon, 28 May 2007 16:53:25 GMT

this worked like a charm, changed tables' schemas perfectly...thanks a ton

re: Change schema name on Tables and Stored procedures in SQL Server 2005

Meron — Tue, 03 Apr 2007 14:06:37 GMT

it would have been more helpful it include a typical sql statement example