Question discussion

Which of the following is not used to delete data from database table?

196744Medium 1 reply 1,418 views
34
Which of the following is not used to delete data from database table?
  • ADELETE Table
  • BDROP Table
  • CTRUNCATE Table
  • DREMOVE Table
Answer not set

Discussion 1

0
CCommunity
The SQL DROP command is used to remove an object from the database. The DELETE Statement is used to delete rows from a table.

The truncate command removes all rows from a table or specified partitions of a table, without logging the individual row deletions. TRUNCATE TABLE is similar to the DELETE statement.

There is no clause as REMOVE in SQL.