Friday, October 30, 2009

How to move an object from one schema to another

There are various reasons you may wish to move an object to a different schema.  The reason may be for security purposes or simply for logical grouping.  No matter the reason, the syntax is rather simple:
ALTER SCHEMA newschema TRANSFER  oldschema.objectname
Took me a bit to find this piece of information, so I found it a worthy post!