[0.14][Docs] Update drop table behavior in spark-ddl docs (#5647)
diff --git a/docs/spark-ddl.md b/docs/spark-ddl.md
index 0c0fed8..07571c6 100644
--- a/docs/spark-ddl.md
+++ b/docs/spark-ddl.md
@@ -132,12 +132,28 @@
## `DROP TABLE`
-To delete a table, run:
+The drop table behavior changed in 0.14.
+
+Prior to 0.14, running `DROP TABLE` would remove the table from the catalog and delete the table contents as well.
+
+From 0.14 onwards, `DROP TABLE` would only remove the table from the catalog.
+In order to delete the table contents `DROP TABLE PURGE` should be used.
+
+### `DROP TABLE`
+
+To drop the table from the catalog, run:
```sql
DROP TABLE prod.db.sample
```
+### `DROP TABLE PURGE`
+
+To drop the table from the catalog and delete the table's contents, run:
+
+```sql
+DROP TABLE prod.db.sample PURGE
+```
## `ALTER TABLE`
