ALTER SCHEMA
Posted by: SQL Server DBA,
on 24 Oct 2011 |
View original | Bookmarked: 0 time(s)
Use this select statement to create a list of ALTER SCHEMA statements for all stored procedures in a SQL Server 2005 database. dbo can be changed to whatever schema name required
USE myDb
GO
SELECT 'ALTER SCHEMA dbo TRANSFER ' + s.Name + '.' + p.Name
FROM sys.Procedures p INNER JOIN
sys.Schemas s on p.schema_id = s.schema_id WHERE s.Name = 'mySchema'
order by p.Name
Use this select statement to create a list of ALTER SCHEMA statements for all tables and views in a SQL Server 2005...