Thinking outside the box

Patron Saint of Lost Yaks

posts - 200, comments - 701, trackbacks - 4

My Links

Advertisement

News

Archives

Post Categories

<< Efficient pagination for large set of data? | Home | Search all code for specific keyword >>

Change schema for all tables

I just helped a guy here http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=98346 with schema
and thought that someone could benefit from this code

exec

sp_MSforeachtable "PRINT '? modify'; ALTER SCHEMA new_schema TRANSFER ?; IF @@ERROR = 0 PRINT '? modified'; PRINT ''"

Related Links

Script out your foreign keys (8/7/2009)
@@ERROR, BEGIN TRY/CATCH and XACT_ABORT (4/7/2009)
Simple script to get referenced table and their column names (6/8/2010)
Avoid stupid mistakes (9/22/2011)
SQL Server 2008 Compression (6/17/2010)

Print | posted on Wednesday, March 05, 2008 1:31 AM | Filed Under [ SQL Server 2008 Administration SQL Server 2005 ]

Feedback

No comments posted yet.

Post Comment

Title
Name
Email
Url
Comment
Remember Me?
Enter the code shown above:

Powered by:

Copyright © Peter Larsson