下列【视图】创建语句错误的是？
A: CREATE VIEW 视图名 AS SELECT语句;
B: CREATE OR REPLACE VIEW 视图名 AS SELECT语句;
C: CREATE VIEW 视图名 SELECT语句 WITH CHECK OPTION;
D: CREATE VIEW 视图名 AS SELECT语句 WITH CHECK OPTION;
A: CREATE VIEW 视图名 AS SELECT语句;
B: CREATE OR REPLACE VIEW 视图名 AS SELECT语句;
C: CREATE VIEW 视图名 SELECT语句 WITH CHECK OPTION;
D: CREATE VIEW 视图名 AS SELECT语句 WITH CHECK OPTION;
举一反三
- 请选择正确的视图创建语句() A: create view视图名as select语句 B: create show视图名as select语句 C: create view视图名as insert语句 D: create show视图名as insert语句
- 创建视图的语法格式是:Create view 视图名称( ) select 查询语句
- 在mysql中,创建视图使用( )语句 A: create table B: create view C: select
- 在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: SHOW VIEW B: SELECT VIEW C: SHOW CREATE VIEW D: DISPLAY VIEW