BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;
 
    -- Insert statements for procedure here
    DECLARE @TableName varchar(800);
    DECLARE @strSQL    varchar(8000);
    DECLARE c1 CURSOR FOR
        SELECT TABLE_NAME
          FROM INFORMATION_SCHEMA.TABLES
    FOR READ ONLY
 
    OPEN c1
    FETCH NEXT FROM c1
    INTO @TableName
 
    -- loop until we run out of rows
    WHILE @@FETCH_STATUS = 0
    BEGIN
 
        IF LEFT (@TableName, 3) = 'tew'
            BEGIN
            SET @strSQL = 'ALTER SCHEMA dbo TRANSFER tew.' + @TableName
            EXECUTE (@strSQL)
            END
 
        FETCH NEXT FROM c1
        INTO @TableName
 
    END
    CLOSE c1
    DEALLOCATE c1
 
END