rename 原试图名 to 现试图名;
ALTER VIEW old_name RENAME TO new_name
rename v1 to v2
CREATE OR REPLACE VIEW vw_emp20
AS SELECT * FROM emp
WHERE deptno=20
WITH CHECK OPTION constraint vw_emp20_ck;
----答案就是create or repplace view ……
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024