修改新建删除视图

--删除视图的语法--
drop view PROTECT.V_QTMENUORDER

--创建视图语句 ---
create view PROTECT.V_QTMENUORDER
as
SELECT ID,TEXT,PID,SEQ FROM  

(SELECT MENUID AS ID,'系统菜单' AS TEXT,PARENTID  AS PID,SEQ FROM PLATFORM.T_TBP_MENU_QT T WHERE MENUID='999999999'
UNION
SELECT MENUID AS ID,'E8000' AS TEXT,PARENTID  AS PID,SEQ FROM PLATFORM.T_TBP_MENU_QT T WHERE PARENTID ='999999999'
)
go


--删除视图的语法--
drop view PROTECT.V_XITONGMENUORDER

--创建视图语句 ---
create view PROTECT.V_XITONGMENUORDER
as
SELECT ID,TEXT,Pid from(
SELECT ID,TEXT,Pid,seq from (select * from PROTECT.V_PEIYONGDIANMENUORDER
UNION
select * from PROTECT.V_OMSMENUORDERNEW
UNION
select * from PROTECT.V_EIPMENUORDER
UNION
select * from PROTECT.V_QTMENUORDER))order by seq
go