drop-table
warningDROP TABLE
Why it's unsafe
DROP TABLE permanently and irreversibly removes the table and all its data; in-flight queries against it fail immediately.
Safe rewrite
Confirm all application references are retired and the table is traffic-free before dropping; archive the data first if it may be needed.
Example
Try it in the playground →Unsafe
DROP TABLE legacy_audit;