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)
Solving OUTLOOK 2010 SEARCH NOT WORKING Issue
Keyboard Shortcuts for Run Command -2
Keyboard shortcuts for Run Command -1
Exclusive access could not be obtained because the...
►
May
(4)
How to transfer blogspot blog to another account
Deadlock in SQL Server
Concatenation in SELECT and SPLIT functions with T...
Can not put more than one ModalPopup control in on...
►
April
(4)
How to Restore SQL Server 2008 to SQL Server 2005
Sys.WebForms.PageRequestManagerParserErrorExceptio...
It’s a Matter of Time and Heart Sinhala & Tamil Al...
'Sys' is undefined - ASP.NET AJAX
►
March
(9)
What is Cloud Computing ?
A Software Engineer’s Feelings…..Touching...
User Define Functions In Java Script
Best Practices for Speeding Up Your Web Site
How to get count with some filtering condition in ...
Java Script Validations
DB Backup, Restore, Shrink
How to Clear Recent Project list or File list from...
Get all the object definitions: SPROC, TRIGGER, VI...
▼
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