Question discussion

Which SQL statement removes a table completely, i.e. both its data and its structure, from the database?

1325Medium DSSSB TGT Computer Science 0 replies 1 views
0

Which SQL statement removes a table completely, i.e. both its data and its structure, from the database?

  • ADROP TABLE
  • BTRUNCATE TABLE
  • CDELETE FROM
  • DREMOVE TABLE
Correct answer: A

Explanation

DROP TABLE deletes the data and the table definition; DELETE removes chosen rows and TRUNCATE empties the table but keeps its structure.

Discussion 0

Nobody has replied yet. Start the discussion!