A: CREATE DATABASE student
B: CREATE VIEW student
C: CREATE PROCEDURE student
D: CREATE TABLE student
举一反三
- 下列语句中正确创建数据库“student”的是（） A: create table student B: create database student C: alter database student D: create view student
- 下面选项中，哪个可以正确创建一个名称为student的数据库？ A: Alter DATABASE student; B: CREATE BASE student; C: CREATE DATABASE student; D: CREATE TABLE student;
- 在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;
- 创建一张student表，以下SQL代码正确吗？ create table student
- 下面哪一条语句可以创建一个student数据库( ) A: CREATE DATABASE student； B: ALTER DATABASE student； C: USE student； D: DROP DATABASE student；
内容
- 0
要显示表student的表结构，可以使用命令______。 A: STRUCTURE student; B: DESCRIBE student; C: SHOW CREATE TABLE student; D: VIEW student;
- 1
下列选项中，（）语句可以删除数据库表Student。 A: drop table Student B: select * from sysobjects where name='Student' C: create table Student D: DROPS DATABASE School
- 2
下列哪条语句可以创建视图( )。 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;
- 3
完成语句：查看表student的结构 create table ；
- 4
以下是修改视图的语句是 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;