SELECT 'ALTER SCHEMA newschema TRANSFER ' + s.Name + '.' + o.Name FROM sys.Objects AS o INNER JOIN sys.Schemas AS s on o.schema_id = s.schema_id WHERE s.Name = 'oldschema' And (o.Type = 'U' Or o.Type = 'P' Or o.Type = 'V')