Monday, April 14, 2008

SQL 2005: Change object schema

So simple that I usually forget the syntax...

USE [WHATEVERDATABSE]
GO
ALTER SCHEMA [NewSchemaName] --change to schema
TRANSFER [OldSchemaName].[ObjectName]
GO

No comments: