Skip to main content

Change Schema in SQL server for list of objects

 -- CREATE SCHEMA dbmigration;


declare @OLDSCHEMA NVARCHAR(50)='dbo' 

declare @NEWSCHEMA NVARCHAR(50)='dbmigration' 


SELECT 'ALTER SCHEMA '+@NEWSCHEMA+' TRANSFER '+@OLDSCHEMA+'.'+ROUTINE_NAME+'; '

  FROM INFORMATION_SCHEMA.ROUTINES

 WHERE ROUTINE_TYPE = 'PROCEDURE'


 And ROUTINE_NAME like 'DB_MIGRATION%'

Comments