要显示表student的表结构，可以使用命令______。
A: STRUCTURE student;
B: DESCRIBE student;
C: SHOW CREATE TABLE student;
D: VIEW student;
A: STRUCTURE student;
B: DESCRIBE student;
C: SHOW CREATE TABLE student;
D: VIEW student;
举一反三
- 下面哪个命令可以用来查看学生表（表名student）的表结构（） A: Select student B: Display student C: Describe student D: Show student
- 创建数据表student的SQL语句为（） 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: DELETE TABLE Student B: DELETE Student C: DROP TABLE Student D: DROP 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;