change schema of all table in sql server 2000
ASP.NET
1
Posts
1
Posters
0
Views
1
Watching
-
Hi:) I have a need to change the schema of all table in a database with sql server 2000. i use following query to change the schema of all table using following query use [databasename] exec sp_MSforeachtable "ALTER SCHEMA new_schema TRANSFER ? PRINT '? modified' " but its works only in the sql server 2005. i have need to change it in sql server 2000. Thanks in advance... Regards, Sri..