创建视图stu的语句为:CREATE VIEW ss AS【1】* FROM s_view WHERE score>=60
举一反三
- 修改视图stu的结构应使用语句ALTER VIEW ss【1】SELECT * FROM s_view WHERE score>=60
- 以下创建视图的语句中,正确的是 A: CREATE st_view AS SELECT sid,sname,ssex FROM stu B: CREATE VIEW st_view SELECT sid,sname,ssex FROM stu C: CREATE VIEW st_view AS sid,sname,ssex FROM stu D: CREATE VIEW st_view AS SELECT sid,sname,ssex FROM stu
- 在student表上创建view_stu视图,正确的语句是( )。 A: CREATE VIEW view_stu IS SELECT * FROM student; B: CREATE VIEW view_stu AS SELECT * FROM student; C: CREATE VIEW view_stu SELECT * FROM student; D: CREATE VIEW SELECT * FROM student AS view_stu;
- 下面用来创建视图的语句是( ) A: create table B: alter view C: drop view D: create view
- 下列哪条语句可以创建视图( )。 A: create view v_student as select * from student; B: alter view v_student as select * from student; C: drop view v_student as select * from student; D: sp_help view v_student as select * from student;