修改视图stu的结构应使用语句ALTER VIEW ss【1】SELECT * FROM s_view WHERE score>=60
举一反三
- 创建视图stu的语句为:CREATE VIEW ss AS【1】* FROM s_view WHERE score>=60
- 下面关于修改视图的SQL语句，那个是正确的（ ）。 A: alter view VIEW01 as select * from users order by age desc B: alter view VIEW02 as select name,avg(score) as avgScore from studentScore C: alter view VIEW03 as select top 10 id,name,password from admin order by id D: alter view VIEW04 as select * from stuent,class where student.classid=class.classid order by class.classid
- 修改视图vsex以查询stinfo表中女学生信息的正确语句是（ ）。 A: ALTER VIEW vsex AS SELECT * FROM stinfo WHERE 姓名 ='女' B: MODIFY TABLE vsex AS SELECT * FROM stinfo WHERE 性别= '女' C: ALTER VIEW vsex AS SELECT * FROM stinfo WHERE 性别 ='女' D: ALTER TABLE vsex AS SELECT * FROM stinfo WHERE 性别= '女'
- 下列哪条语句可以创建视图( )。 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;
- 使用SQL语句查询视图v_student的所有数据，下列语句正确的是_______。 A: create view v_studentas....... B: alter view v_studentas....... C: select * from v_student D: drop view v_student