下列SQL语句中,可以删除数据表test的是( )
A: DELETE FROM test ;
B: DROP TABLE test;
C: DELETE test;
D: ALTER TABLE test DROP test;
A: DELETE FROM test ;
B: DROP TABLE test;
C: DELETE test;
D: ALTER TABLE test DROP test;
举一反三
- 删除test表中所有数据的语句为 A: drop table test; B: delete table test; C: delete from test; D: truncate test;
- 从当前数据库中删除Test表的语句为 A: DELETE TABLE Test B: DELETE Test C: DROP Test D: DROP TABLE Test
- 删除数据库Test的正确SQL语句是( ) A: Drop DataBase Test B: Delete DataBase Test C: Alter DataBase Test D: Delete From DataBase Test
- 在关系模式test(学号,姓名,性别,年 龄)中,删除属性“年龄”的命令是( ) A: DELETE 年龄 FROM test B: ALTER TABLE test DROP 年龄 C: UPDATE test SET 年龄 D: ALTER TABLE test ADD 年龄
- 删除数据库test的命令是______. A: delete DATABASE test; B: DROP DATABASE test; C: DROP test; D: delete test;