下列哪条语句可以创建视图( )。 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 or replace view st1 as select* from student; B: alter view st1 as select name from student join class on student.cid=class.id; C: alter table st1 modify class int(3); D: create or replace table st1 as select* from student;

创建一张student表，以下SQL代码正确吗？ create table student

要显示表student的表结构，可以使用命令______。 A: STRUCTURE student; B: DESCRIBE student; C: SHOW CREATE TABLE student; D: VIEW student;

用于删除数据表student正确的语句是： A: drop student B: delete student C: drop database student D: drop table student