以下语句能正确删除数据表“Student”的是（ ）。
A: DELETE TABLE Student
B: DROP Student
C: DROP TABLE Student
D: DELETE Student
A: DELETE TABLE Student
B: DROP Student
C: DROP TABLE Student
D: DELETE Student
C
举一反三
- 删除数据表student的命令是________。 A: drop table student; B: drop student; C: delete table student; D: drop student;
- 删除数据表Student中的数据，应该使用（）。 A: Drop Table Student B: Delete from Student C: Delete table D: Drop Student
- 用于删除数据表student正确的语句是： A: drop student B: delete student C: drop database student D: drop table student
- 删除当前数据库中的表Student的语句应当是（ ）。 A: DELETE TABLE Student B: DELETE Student C: DROP Student D: DROP TABLE Student
- 若要删除数据库中已经存在的表Student,可( )。 A: DELETE TABLE Student B: DELETE Student C: DROP Student D: DROP TABLE Student
内容
- 0
如果要删除数据库中已经存在的表Student，可以使用（）。 A: DELETE TABLE Student B: DELETE Student C: DROP TABLE Student D: DROP Student
- 1
删除学生信息表student的所有数据，正确的语句为（ ）。 A: delete from student B: drop all from student C: delete all * from student D: drop table student
- 2
删除当前数据库中名为Student的表，以下SQL语句正确的是______。 A: DROP TABLE Student B: DELETE TABLE Student C: REMOVE TABLE Student D: CLEAR TABLE Student
- 3
删除student表所有的记录，下列语句正确的是 A: DELETE FROM TABLE student; B: DELETE TABLE student; C: TRUNCATE TABLE student; D: TRUNCATE FROM TABLE student;
- 4
删除STUDENT表中C2的默认值约束语句是（）。 A: ALTER TABLE STUDENT DROP CONSTRAINT C2 B: DROP CONSTRAINT C2 C: DELETE CONSTRAINT C2 D: DROP STUDENT