alter schema, rename schema in sql « treasure4developer

alter schema, rename schema in sql

ALTER SCHEMA destinationschema TRANSFER sourceschema.objectname

from http://sql-articles.com/scripts/change-transfer-schema-for-all-objects/

Rate this:

Like this:

Be the first to like this post.

This entry was written by treasure4developer and posted on September 12, 2011 at 9:33 am and filed under Uncategorized with tags rename, Schema. Bookmark the permalink. Follow any comments here with the RSS feed for this post. Post a comment or leave a trackback: Trackback URL.

Post a Comment

Follow

Follow “treasure4developer”

Powered by WordPress.com