Yes
Nobody knows everything, but everybody knows something
Search This Blog
Monday, September 26, 2011
Change schema for all tables
exec
sp_MSforeachtable
"PRINT '? modify'; ALTER SCHEMA dbo TRANSFER ?; IF @@ERROR = 0 PRINT '? modified'; PRINT ''"
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment