在informix 如何修改view ??

[tommyyuyong]

现有在informix中建立view ,但建立后不知如何去修改,只能drop view 重新建立!
以下是建立view SQL:
create view view_nme (b1,b2,b3,b4,b5) as
select nme01,nme02,nme12,
case nmc03 when '2' then round(nme04*-1,3) else round(nme04,3) end,
trim(nme01)||year(nme02)||month(nme02)||
case nmc03 when '2' then round(nme04*-1,3) else round(nme04,3) end
from nme_file,nmc_file
where nme03=nmc01;

[wenlq]

好象跟存储过程一样
只能drop 后 再create

[cloudflashes]

drop view view_nme ，
然后再create view view_nme