若要删除book表中所有数据,以下语句正确的是( )。
A: TRUNCATE TABLE book
B: TRUNCATE book
C: TRUNCATE FROM book
D: TRUNCATE * TABLE book
A: TRUNCATE TABLE book
B: TRUNCATE book
C: TRUNCATE FROM book
D: TRUNCATE * TABLE book
A
举一反三
- 若要删除book表中所有数据包含约束等,以下语句正确的是()。 A: truncate table book B: delete * from book C: drop table book D: delete from table
- 若要删除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 FROM book
- 若要删除book表中所有数据,以下语句错误的是() A: Atruncate table book B: Bdelete * from book C: Cdrop table book D: Ddelete from book
- 若要删除book表中所有数据,以下语句正确的是( )。 A: delete table book B: delete * from book C: drop book D: delete from book
内容
- 0
若要删除book表中的所有数据,以下语句正确的是() A: DROP<br/>FROM book B: DROP<br/>TABLE book C: DELETE<br/>FROM book D: DELETE<br/>TABLE book
- 1
若要删除book表中所有数据,以下语句错误的是( )。(多选) A: drop * from book B: delete * from book C: drop table book D: delete from book
- 2
删除student表所有的记录,下列语句正确的是 A: DELETE FROM TABLE student; B: DELETE TABLE student; C: TRUNCATE TABLE student; D: TRUNCATE FROM TABLE student;
- 3
删除表中的所有记录() A: delete from表名 B: drop table表名 C: truncate from表名 D: truncate table表名
- 4
删除test表中所有数据的语句为 A: drop table test; B: delete table test; C: delete from test; D: truncate test;