使用SQL语句创建视图v_student,下列语句正确的是_______。
A: create view v_studentas.......
B: alter view v_studentas.......
C: drop view v_student
D: 以上ABC都不是
A: create view v_studentas.......
B: alter view v_studentas.......
C: drop view v_student
D: 以上ABC都不是
举一反三
- 使用SQL语句查询视图v_student的所有数据，下列语句正确的是_______。 A: create view v_studentas....... B: alter view v_studentas....... C: select * from v_student D: drop view v_student
- 下列哪条语句可以创建视图( )。 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;
- 下面用来创建视图的语句是（ ） A: create table B: alter view C: drop view D: create view
- 创建视图是通过（ ）语句实现的。 A: show view B: create view C: drop view D: alter view
- 通常使用（ ）语句删除视图 A: DROP VIEW B: DELETE VIEW C: ALTER VIEW D: CREATE VIEW