若要删除book表中所有数据，以下语句正确的是（选一项）
A: truncate table book
B: delete * from book
C: drop table book
D: delete table book
A: truncate table book
B: delete * from book
C: drop table book
D: delete table book
A
举一反三
- 若要删除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<br/>FROM book B: DROP<br/>TABLE book C: DELETE<br/>FROM book D: DELETE<br/>TABLE book
- 若要删除book表中所有数据,以下语句错误的是( )。(多选) A: drop * from book B: delete * from book C: drop table book D: delete from book
- 若要删除book表中所有数据，以下语句正确的是( )。 A: TRUNCATE TABLE book B: TRUNCATE book C: TRUNCATE FROM book D: TRUNCATE * TABLE book
内容
- 0
下列语句用来删除表对象或表数据，其中不正确的语句是（）。 A: TRUNCATE TABLE book B: DELETE * FROM book C: DROP TABLE book D: DELETE FROM book
- 1
若要删除book表中所有数据，以下语句错误的是（） A: Atruncate table book B: Bdelete * from book C: Cdrop table book D: Ddelete from book
- 2
下列语句用来删除数据表中指定记录，正确的语句是（ ）。 A: DELETE FROM book WHERE 单价>20 B: DELETE * FROM book C: DELETE FROM book HAVING 单价>20 D: DELETE FROM book
- 3
删除test表中所有数据的语句为 A: drop table test; B: delete table test; C: delete from test; D: truncate test;
- 4
SQL用来删除表的语句是()。 A: DELETE B: DROP TABLE C: TRUNCATE TABLE D: DELETE TABLE