Change Schema for Tables of a Database in SQL Server

<< Windows Vista and SharePoint Slow Issue | Home | 50 Excellent Digital Photography Guides for Photoshop >>

Change Schema for Tables of a Database in SQL Server

Run this query against your database, set new_schema as your desired schema, e.g. dbo

exec sp_MSforeachtable "ALTER SCHEMA new_schema TRANSFER ? PRINT '? modified' "

Print | posted on Saturday, November 29, 2008 3:39 PM

Comments on this post

# re: Change Schema for Tables of a Database in SQL Server

This is exactly why we need a non rdbms, schemaless database which changes itself as the data evolves and doesn't require us to do any thing once development is started. check this out. Brainwave Platform.

-Benny

Left by Semantic Database on Dec 23, 2008 4:00 PM

Your comment:

Title:

Name:

Email: (never displayed)

(will show your gravatar)

Website:

Comment: Allowed tags: blockquote, a, strong, em, p, u, strike, super, sub, code

Please add 3 and 3 and type the answer here:

Enter the code shown above:

Tech Guru