DECLARE @sqlcommand NVARCHAR(MAX),@db_py NVARCHAR(50)
SET @db_py='PY202'
SET @sqlcommand='USE '+QUOTENAME(@db_py)+'
GO
ALTER VIEW test AS
SELECT * FROM PY_S01
UNION ALL
SELECT * FROM PY_S02';
SET @sqlcommand='ALTER VIEW test AS SELECT * FROM PY_S01 UNION ALL SELECT * FROM PY_S02';
SET @sqlcommand=REPLACE(@sqlcommand,'ALTER VIEW test','ALTER VIEW'+SPACE(1)+QUOTENAME(@db_py)+'.DBO.test ');
EXEC(@sqlcommand)