删除学生信息表student的所有数据，正确的语句为（ ）。
A: delete from student
B: drop all from student
C: delete all * from student
D: drop table student
A: delete from student
B: drop all from student
C: delete all * from student
D: drop table student
A
举一反三
- 删除数据表Student中的数据，应该使用（）。 A: Drop Table Student B: Delete from Student C: Delete table D: Drop Student
- 【单选题】删除 student 表的所有数据 A. delete * from student B. delete all from student C. delete from student D. delete rows from student
- 从学生表中删除学号为“1001”的学生记录，正确的SQL语句是______。 A: DROP FROM Student WHERE 学号="1001" B: DROP FROM Student FOR 学号="1001" C: DELETE FROM Student WHERE 学号="1001" D: DELETE FROM Student FOR 学号="1001"
- 删除当前数据库中的表Student的语句应当是（ ）。 A: DELETE TABLE Student B: DELETE Student C: DROP Student D: DROP TABLE Student
- 以下语句能正确删除数据表“Student”的是（ ）。 A: DELETE TABLE Student B: DROP Student C: DROP TABLE Student D: DELETE Student
内容
- 0
删除student表所有的记录，下列语句正确的是 A: DELETE FROM TABLE student; B: DELETE TABLE student; C: TRUNCATE TABLE student; D: TRUNCATE FROM TABLE student;
- 1
用于删除数据表student正确的语句是： A: drop student B: delete student C: drop database student D: drop table student
- 2
若要删除数据库中已经存在的表Student,可( )。 A: DELETE TABLE Student B: DELETE Student C: DROP Student D: DROP TABLE Student
- 3
删除数据表student的命令是________。 A: drop table student; B: drop student; C: delete table student; D: drop student;
- 4
如果要删除数据库中已经存在的表Student，可以使用（）。 A: DELETE TABLE Student B: DELETE Student C: DROP TABLE Student D: DROP Student