skip to main
|
skip to sidebar
Chamila's Blog
Pages
Home
About Me
How to reach me
Important and Useful Links
Monday, February 28, 2011
How to Change Schema for Tables, Views and Stored Procedures
SELECT 'ALTER SCHEMA dbo TRANSFER ' + s.Name + '.' + o.Name
FROM sys.Objects o
INNER JOIN sys.Schemas s on o.schema_id = s.schema_id
WHERE s.Name = 'yourschema'
And (o.Type = 'U' Or o.Type = 'P' Or o.Type = 'V')
0 comments:
Post a Comment
Newer Post
Older Post
Home
About Me
I can’t change the direction of the wind, but I can adjust my sails to always reach my destination.
View My Profile
Blog Archive
▼
2011
(23)
►
October
(4)
►
May
(4)
►
April
(4)
►
March
(9)
▼
February
(2)
How to Change Schema for Tables, Views and Stored ...
How to Change DB Owner for Tables , Views and Stor...
►
2009
(1)
►
April
(1)
Labels
.NET
(1)
AJAX
(3)
Blogger
(1)
Java Script
(2)
LIFE
(2)
Microsoft SQL
(9)
Office
(1)
Web
(2)
Windows
(2)
Counter
Free Hit Counter
Get 100 FREE Visitors to Your Website!
Feedjit
Feedjit Live Blog Stats
Followers
COUNTDOWN TO 2012
Powered by
Blogger
.
0 comments:
Post a Comment