存储过程可以包含alter view语句

ALTER proc [dbo].[p_sys_alterView]
as
begin
    
    exec ('alter view [dbo].[V_L0]
        as
        select * from  B 
        ');
   exec ('alter view [dbo].[V_LB]
        as
        select * from  B where  AA = ''2052''
        ');
end