Thinking outside the box

Patron Saint of Lost Yaks

posts - 202, comments - 734, trackbacks - 4

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 ''"

This little piece of code has helped me so many times! Thanks for sharing!

5/27/2012 10:12 AM | Chris

Comments have been closed on this topic.