SQL DROP Statement Generator
Generate safe DROP statements for PostgreSQL, MySQL, SQLite, SQL Server, and Oracle. Tables, columns, indexes, views, triggers, and functions with dependency warnings.
1. Dialect & Object
2. Options
⚠️ Safety Warning: Dropping a table permanently deletes all data. Check for foreign keys, views, triggers, and functions that reference this object before dropping.
PostgreSQL supports IF EXISTS and CASCADE on most objects. MySQL supports IF EXISTS. SQL Server uses DROP IF EXISTS syntax in 2016+. Oracle supports CASCADE CONSTRAINTS.
3. Generated SQL
-- Select an object type and configure options above
Quick Examples
Drop Table
Safe DROP TABLE IF EXISTS with CASCADE for referenced objects.
PostgreSQLMySQL
Drop Column
Remove a column safely with IF EXISTS where supported.
All Dialects
Drop Index
Remove an index without affecting table data.
Performance
Drop View
Remove a view that is no longer needed.
Safe
Drop Trigger
Remove a trigger without touching the table.
Maintenance
Drop Function
Remove a stored function or procedure.
Cleanup