SQL Server: How to Transfer All Objects of a Schema

added by lionofdezert
2/7/2011 11:04:10 AM

2 Kicks, 75 Views

There is no t-sql syntax to transfer all objects from one schema to other, even there is no t-sql syntax to rename a schema. We can only transfer objects one by one from one schema to other.