Alter schema for multiple tables in SQL Server

create schema stage

SELECT 'ALTER SCHEMA stage TRANSFER [' + SysSchemas.Name + '].[' + DbObjects.Name + '];'
FROM sys.Objects DbObjects
INNER JOIN sys.Schemas SysSchemas 
ON DbObjects.schema_id = SysSchemas.schema_id
WHERE SysSchemas.Name = 'dbo'AND (DbObjects.Type IN ('U', 'P', 'V'))

---- U - Table (user-defined)
---- P - SQL Store procedures
---- V - SQL View