Change Schema for Tables of a Database in SQL Server

posted @ Saturday, November 29, 2008 3:39 PM

 

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' "

Comments
Semantic Database - 12/23/2008 4:00 PM
# 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
Post Comment






Please add 4 and 5 and type the answer here: