下列语句用来删除表对象或表数据,其中不正确的语句是()。
A: TRUNCATE TABLE book
B: DELETE * FROM book
C: DROP TABLE book
D: DELETE FROM book
A: TRUNCATE TABLE book
B: DELETE * FROM book
C: DROP TABLE book
D: DELETE FROM book
举一反三
- 若要删除book表中所有数据,以下语句正确的是(选一项) A: truncate table book B: delete * from book C: drop table book D: delete table book
- 若要删除book表中所有数据包含约束等,以下语句正确的是()。 A: truncate table book B: delete * from book C: drop table book D: delete from table
- 若要删除book表中所有数据,以下语句正确的是( )。 A: delete table book B: delete * from book C: drop book D: delete from book
- 若要删除book表中所有数据,以下语句错误的是( )。(多选) A: drop * from book B: delete * from book C: drop table book D: delete from book
- 若要删除book表中的所有数据,以下语句正确的是() A: DROP<br/>FROM book B: DROP<br/>TABLE book C: DELETE<br/>FROM book D: DELETE<br/>TABLE book