Is there any way to remove data other than truncate and delete in SQL?

Data Science, AI and ML
,
#1

The other operations which results in removal of existing data from tables is by

  • Dropping the table itself using DROP TABLE… IF EXISTS option

  • Updating all columns data to NULL or any default value like ‘’ using UPDATE statement

  • FK created with cascading delete options which causes deletion to happen on background from child tables when parent entries get deleted without any explicit delete/truncate performed on child table