Friday, May 12, 2006

Changing The Schema Of A Table In SQL Server 2005

Since I am still in unpacking and putting up light-fixtures mode I decided to link to a cool post on the SQL Doctor's blog
It covers the process of changing the schema for a table
All you need to do is this
ALTER SCHEMA [schemaName] TRANSFER [otherSchemaName].[objectName]

Here is the link (http://spaces.msn.com/drsql/blog/cns!80677FB08B3162E4!1041.entry)

And don't let Fred, Barney, Wilma or Betty fool you

No comments: